23-02356-number-of-unique-subjects-taught-by-each-teacher.sql

-- just need to check distinct subjects for each teacher
-- count(distinct variable) function


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

-- capgemini- 1