Retrieve all the first and last names of authors in the alphabetical order of last names.
SELECT fname ,  lname FROM authors ORDER BY lname
first and last names of authors = SELECT fname, lname; alphabetical order of last names = ORDER BY lname;