CREATE TABLE papers (paperid NUMBER, title CLOB)
CREATE TABLE authorship (authid NUMBER, instid NUMBER, paperid NUMBER, authorder NUMBER)
CREATE TABLE inst (instid NUMBER, name CLOB, country CLOB)
CREATE TABLE authors (authid NUMBER, lname CLOB, fname CLOB)

Retrieve all the last names of authors in alphabetical order.
SELECT lname FROM authors ORDER BY lname
SELECT "lname" FROM "authors" ORDER BY "lname"