Retrieve all the first and last names of authors in the alphabetical order of last names.
CREATE TABLE authors (fname VARCHAR, lname VARCHAR)
[SQL] SELECT fname, lname FROM authors ORDER BY lname [/SQL]