For each grade, return the grade number, the number of classrooms used for the grade, and the total number of students enrolled in the grade.
CREATE TABLE list (
    lastname text,
    firstname text,
    grade number,
    classroom number
)

CREATE TABLE teachers (
    lastname text,
    firstname text,
    classroom number
)
SELECT grade, COUNT(DISTINCT classroom), COUNT(*) FROM list GROUP BY grade
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 grade, return the grade number, the number of classrooms used for the grade, and the total number of students enrolled in the grade. ### Input: CREATE TABLE list (
    lastname text,
    firstname text,
    grade number,
    classroom number
)

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