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

Sort the first names of all the authors in alphabetical order.
SELECT fname FROM authors ORDER BY fname
SELECT "fname" FROM "authors" ORDER BY "fname"