[SQL 코드카타] 99번 (LeetCode)

99번 number-of-unique-subjects-taught-by-each-teacher

SELECT
    teacher_id, count(distinct subject_id) as cnt
FROM
    teacher
GROUP BY
    teacher_id