-- Database schema
| workshop : Workshop_ID [ INT ] primary_key , Date [ TEXT ] , Venue [ TEXT ] , Name [ TEXT ] | submission : Submission_ID [ INT ] primary_key , Scores [ INT ] , Author [ TEXT ] , College [ TEXT ] | Acceptance : Submission_ID [ INT ] primary_key Acceptance.Submission_ID = submission.Submission_ID , Workshop_ID [ INT ] Acceptance.Workshop_ID = workshop.Workshop_ID , Result [ TEXT ] |
-- -- Show different colleges along with the number of authors of submission from each college.

SELECT College ,  COUNT(*) FROM submission GROUP BY College;