SQL problem - Number of Unique Subjects Taught by Each Teacher
Problem
Query
SELECT
teacher_id,
COUNT(DISTINCT subject_id) as cnt
FROM
Teacher
GROUP BY
teacher_id
You may also enjoy
Problem of The Day: Find Minimum Time to Reach Last Room II
Problem Statement
Problem of The Day: Number of Equivalent Domino Pairs
Problem Statement
Problem of The Day: Minimum Domino Rotations For Equal Row
Problem Statement
Problem of The Day: Push Dominoes
Problem Statement