I'm working with MySQL in my database class and can't figure out an answer.?

I'm working out of the murach's MySQL 3rd edition and I'm in chapter 3. The problem I'm stuck on says, Write a SELECT statement that returns one column from the vendors table named full_name that joins the vendor_contact_last_name and vendor_contact_first_name columns. Format the column with the last name, a comma, a space, a comma, and the first name like this DOE, JOHN. Sort the result set by first name and last name in accessing order. Return only the contacts whose last name begins with the letter A, B, C, or E. This should retrieve 41 rows.

I've tried looking through the chapter and can't figure it out to save my life, any help would be appreciated.