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: Next Greater Element II
Problem Statement
Problem of The Day: Find Building Where Alice and Bob Can Meet
Problem Statement
Problem of The Day: Reverse Odd Levels of Binary Tree
Problem Statement