How many authors have sumbitted their work?
select count(author) from submission
Please show their colleges.
select college from submission
How many unique colleges are there?
select count(distinct college) from submission
Among these colleges, which one has the most submissions?
select college from submission group by college order by count(*) desc limit 1