CREATE TABLE authors (fname VARCHAR2, lname VARCHAR2)

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"