Scatter plot to show classroom on x axis and the total number on y axis.
CREATE TABLE list (
    LastName TEXT,
    FirstName TEXT,
    Grade INTEGER,
    Classroom INTEGER
)

CREATE TABLE teachers (
    LastName TEXT,
    FirstName TEXT,
    Classroom INTEGER
)
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: Scatter plot to show classroom on x axis and the total number on y axis. ### Input: CREATE TABLE list (
    LastName TEXT,
    FirstName TEXT,
    Grade INTEGER,
    Classroom INTEGER
)

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