SELECT fname ,  lname FROM authors ORDER BY lname
Sort the list of all the first and last names of authors in alphabetical order of the last names.
SELECT fname , lname FROM authors ORDER BY lname
select fname , lname from authors order by lname
Sort the list of all the first and last names of authors in alphabetical order of the last names .