SQL problem - Number of Unique Subjects Taught by Each Teacher

1 min read 40 words

Problem

Query

SELECT
    teacher_id,
    COUNT(DISTINCT subject_id) as cnt
FROM
    Teacher
GROUP BY
    teacher_id