Task: Text to Code
Input (English): SQL: SELECT BlockCode , Count ( * ) FROM Room GROUP BY BlockCode
Feedback: Find different Room's block code with number of corresponding rows to each value in room room table .
Output (English): 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