For each classroom, show the classroom number and find how many students are using it.
CREATE TABLE teachers (
    lastname text,
    firstname text,
    classroom number
)

CREATE TABLE list (
    lastname text,
    firstname text,
    grade number,
    classroom number
)
SELECT classroom, COUNT(*) FROM list GROUP BY classroom
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: For each classroom, show the classroom number and find how many students are using it. ### Input: CREATE TABLE teachers (
    lastname text,
    firstname text,
    classroom number
)

CREATE TABLE list (
    lastname text,
    firstname text,
    grade number,
    classroom number
) ### Response: SELECT classroom, COUNT(*) FROM list GROUP BY classroom