Find the number of classes in each school.
CREATE TABLE CLASS (
    crs_code VARCHAR
)

CREATE TABLE department (
    school_code VARCHAR,
    dept_code VARCHAR
)

CREATE TABLE course (
    crs_code VARCHAR,
    dept_code VARCHAR
)
SELECT COUNT(*), T3.school_code FROM CLASS AS T1 JOIN course AS T2 ON T1.crs_code = T2.crs_code JOIN department AS T3 ON T2.dept_code = T3.dept_code GROUP BY T3.school_code
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: Find the number of classes in each school. ### Input: CREATE TABLE CLASS (
    crs_code VARCHAR
)

CREATE TABLE department (
    school_code VARCHAR,
    dept_code VARCHAR
)

CREATE TABLE course (
    crs_code VARCHAR,
    dept_code VARCHAR
) ### Response: SELECT COUNT(*), T3.school_code FROM CLASS AS T1 JOIN course AS T2 ON T1.crs_code = T2.crs_code JOIN department AS T3 ON T2.dept_code = T3.dept_code GROUP BY T3.school_code