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

Count the number of authors.
SELECT COUNT(*) FROM authors
SELECT COUNT(*) FROM "authors"