2025-08-19 08:34:12 +0000 UTC

Number of Unique Subjects Taught by Each Teacher

Code

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