Return a scatter on how many students does one classroom have?
CREATE TABLE teachers (
    LastName TEXT,
    FirstName TEXT,
    Classroom INTEGER
)

CREATE TABLE list (
    LastName TEXT,
    FirstName TEXT,
    Grade INTEGER,
    Classroom INTEGER
)
SELECT COUNT(*), Classroom 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: Return a scatter on how many students does one classroom have? ### Input: CREATE TABLE teachers (
    LastName TEXT,
    FirstName TEXT,
    Classroom INTEGER
)

CREATE TABLE list (
    LastName TEXT,
    FirstName TEXT,
    Grade INTEGER,
    Classroom INTEGER
) ### Response: SELECT COUNT(*), Classroom FROM list GROUP BY Classroom