SQL/문제풀이

Number of Unique Subjects Taught by Each Teacher _ Easy. LeetCode

데이터분석가 이채은 2024. 10. 14. 02:56

 

Solution

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