SELECT College ,  COUNT(*) FROM submission GROUP BY College
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
Show different colleges along with the number of authors of submission from each college .