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