How many rooms does each block floor have?
SELECT count(*) ,  T1.blockfloor FROM BLOCK AS T1 JOIN room AS T2 ON T1.blockfloor  =  T2.blockfloor AND T1.blockcode  =  T2.blockcode GROUP BY T1.blockfloor
SELECT count(*) ,  T1.blockfloor FROM BLOCK AS T1 JOIN room AS T2 ON T1.blockfloor  =  T2.blockfloor AND T1.blockcode  =  T2.blockcode GROUP BY T1.blockfloor
[{'count(*)': 9, 'BlockFloor': 1}, {'count(*)': 9, 'BlockFloor': 2}, {'count(*)': 9, 'BlockFloor': 3}, {'count(*)': 9, 'BlockFloor': 4}]