2356. Number of Unique Subjects Taught by Each Teacher (Easy).sql

SELECT teacher_id,COUNT(DISTINCT subject_id)
FROM teacher_2356
GROUP BY teacher_id;