Table schema:
CREATE TABLE submission (College VARCHAR)

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