Database: network_1
Question: Show the student IDs and numbers of friends corresponding to each.
SQL:
SELECT student_id ,  count(*) FROM Friend GROUP BY student_id