2356-number-of-unique-subjects-taught-by-each-teacher

DevGod

Vtuber

Caution

DevGod needs to write an editorial for this problem!

sql

# Write your MySQL query statement below
SELECT teacher_id, COUNT(DISTINCT subject_id) AS cnt
FROM Teacher
GROUP BY teacher_id