Show different colleges along with the number of authors of submission from each college.
CREATE TABLE workshop (
    workshop_id number,
    date text,
    venue text,
    name text
)

CREATE TABLE submission (
    submission_id number,
    scores number,
    author text,
    college text
)

CREATE TABLE acceptance (
    submission_id number,
    workshop_id number,
    result text
)
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 workshop (
    workshop_id number,
    date text,
    venue text,
    name text
)

CREATE TABLE submission (
    submission_id number,
    scores number,
    author text,
    college text
)

CREATE TABLE acceptance (
    submission_id number,
    workshop_id number,
    result text
) ### Response: SELECT college, COUNT(*) FROM submission GROUP BY college