문제
입력 코드
SELECT teacher_id, COUNT(DISTINCT(subject_id)) AS cnt
FROM Teacher
GROUP BY teacher_id;
코드 설명
#SELECT #COUNT #DISTINCT #GROUP BY
문제 출처
LeetCode - The World's Leading Online Programming Learning Platform
Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.
leetcode.com
'SQL' 카테고리의 다른 글
| #99. [LeetCode / MySQL] 1070. Product Sales Analysis III (0) | 2023.09.25 |
|---|---|
| #98. [LeetCode / MySQL] 1141. User Activity for the Past 30 Days I (0) | 2023.09.24 |
| #96. [LeetCode / MySQL] 550. Game Play Analysis IV (0) | 2023.09.22 |
| #95. [LeetCode / MySQL] 1174. Immediate Food Delivery II (0) | 2023.09.21 |
| #94. [LeetCode / MySQL] 1193. Monthly Transactions I (0) | 2023.09.20 |