2356.sql (86B)
1 SELECT teacher_id, COUNT(DISTINCT subject_ID) AS cnt 2 FROM Teacher 3 GROUP BY teacher_id