Table 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