Translate the following question to SQL: Report the number of students in each classroom.

Schema: CREATE TABLE list (
    LastName TEXT   PRIMARY KEY,
    FirstName TEXT   PRIMARY KEY,
    Grade INTEGER,
    Classroom INTEGER,
    PRIMARY KEY (LastName, FirstName),
    UNIQUE (LastName, FirstName)
);

CREATE TABLE teachers (
    LastName TEXT   PRIMARY KEY,
    FirstName TEXT   PRIMARY KEY,
    Classroom INTEGER,
    PRIMARY KEY (LastName, FirstName),
    UNIQUE (LastName, FirstName)
);
user
SELECT classroom ,  count(*) FROM list GROUP BY classroom
assistant