CREATE TABLE submission (College VARCHAR2)

Show different colleges along with the number of authors of submission from each college.
SELECT College, COUNT(*) FROM submission GROUP BY College
SELECT "College", COUNT(*) FROM "submission" GROUP BY "College"