2025-08-19 11:34:12 +0300 MSK

Number of Unique Subjects Taught by Each Teacher

Code

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