Task: Text to Code
Input (English): How many friends does each student have?
Output (English): SELECT student_id ,  count(*) FROM Friend GROUP BY student_id