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

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" NULLS FIRST