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