SQL
leetcode 2356. Number of Unique Subjects Taught by Each Teacher
무적김두칠
2023. 4. 6. 15:45
https://leetcode.com/problems/number-of-unique-subjects-taught-by-each-teacher/description/
Number of Unique Subjects Taught by Each Teacher - LeetCode
Can you solve this real interview question? Number of Unique Subjects Taught by Each Teacher - 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
|
1
2
3
4
|
# Write your MySQL query statement below
select teacher_id , count(distinct subject_id) cnt
from Teacher
group by teacher_id
|
cs |
반응형