[LeetCode] 2356. Number of Unique Subjects Taught by Each Teacher

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

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