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: Smallest Number With All Set Bits
Problem Statement
Problem of The Day: Make Array Elements Equal to Zero
Problem Statement
Problem of The Day: Number of Laser Beams in a Bank
Problem Statement
Problem of The Day: Simple Bank System
Problem Statement