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

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"