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

For each college, return the college name and the count of authors with submissions from that college.
SELECT college, COUNT(*) FROM submission GROUP BY college
SELECT "college", COUNT(*) FROM "submission" GROUP BY "college"