Task: Text to Code
Input (English): Step 1: for each value of School_ID in school table, calculate number of rows.
Step 2: show each value of School_ID in school table along with the corresponding number of rows ordered descending by the results of step 1
Output (English): SELECT Boys_or_Girls , Count ( * ) FROM school GROUP BY School_ID ORDER BY Count ( * ) Desc