2356-number-of-unique-subjects-taught-by-teacher.sql

/** 2356. Number of Unique Subjects Taught by Each Teacher - https://leetcode.com/problems/number-of-unique-subjects-taught-by-each-teacher/ **/

select teacher_id, count(distinct subject_id) as cnt
from teacher
group by teacher_id