Find the number of rooms with more than 50 capacity for each building.
CREATE TABLE classroom (
    building VARCHAR,
    capacity INTEGER
)
SELECT COUNT(*), building FROM classroom WHERE capacity > 50 GROUP BY building
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 rooms with more than 50 capacity for each building. ### Input: CREATE TABLE classroom (
    building VARCHAR,
    capacity INTEGER
) ### Response: SELECT COUNT(*), building FROM classroom WHERE capacity > 50 GROUP BY building