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