Show different colleges along with the number of authors of submission from each college.
create table submission (college varchar, PRIMARY KEY (college))
select college, count(*) from submission group by college