Show different colleges along with the number of authors of submission from each college.
CREATE TABLE submission (
    College VARCHAR
)
SELECT College, COUNT(*) FROM submission GROUP BY College
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show different colleges along with the number of authors of submission from each college. ### Input: CREATE TABLE submission (
    College VARCHAR
) ### Response: SELECT College, COUNT(*) FROM submission GROUP BY College