SELECT College ,  COUNT(*) FROM submission GROUP BY College
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
For each college , return the college name and the count of authors with submissions from that college .