Find the number of rooms for different block code?
CREATE TABLE BLOCK (
    blockcode VARCHAR,
    blockfloor VARCHAR
)

CREATE TABLE room (
    blockfloor VARCHAR,
    blockcode VARCHAR
)
SELECT COUNT(*), T1.blockcode FROM BLOCK AS T1 JOIN room AS T2 ON T1.blockfloor = T2.blockfloor AND T1.blockcode = T2.blockcode GROUP BY T1.blockcode
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 for different block code? ### Input: CREATE TABLE BLOCK (
    blockcode VARCHAR,
    blockfloor VARCHAR
)

CREATE TABLE room (
    blockfloor VARCHAR,
    blockcode VARCHAR
) ### Response: SELECT COUNT(*), T1.blockcode FROM BLOCK AS T1 JOIN room AS T2 ON T1.blockfloor = T2.blockfloor AND T1.blockcode = T2.blockcode GROUP BY T1.blockcode