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

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