CREATE TABLE submission (submission_id NUMBER, scores NUMBER, author CLOB, college CLOB)
CREATE TABLE acceptance (submission_id NUMBER, workshop_id NUMBER, result CLOB)
CREATE TABLE workshop (workshop_id NUMBER, date CLOB, venue CLOB, name CLOB)

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