Task: Text to Code
Input (English): Step 1: for each value of year in takes table, calculate number of rows.
Step 2: show each value of year in takes table along with the corresponding number of rows with largest value in the results of step 1
Output (English): SELECT year , Count ( * ) FROM takes GROUP BY year ORDER BY Count ( * ) Desc LIMIT 1