number-of-unique-subjects-taught-by-each-teacher.sql

# Time:  O(n)
# Space: O(n)

SELECT teacher_id, COUNT(DISTINCT subject_id) AS cnt
FROM Teacher
GROUP BY teacher_id
ORDER BY NULL;