Task: Text to Code
Input (English): find each value of School_ID in school table along with the number of the corresponding rows to each value
Output (English): SELECT Boys_or_Girls , Count ( * ) FROM school GROUP BY School_ID