For each classroom, report the classroom number and the number of grades 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(DISTINCT grade) 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, report the classroom number and the number of grades 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(DISTINCT grade) FROM list GROUP BY classroom