commit 1a09407d602268dc36ade1c7dbb4ec1a4c1345b5 parent d18ba73880ce7207168739d0e0fa1237cb2e9d6b Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Tue, 4 Jul 2023 15:45:25 -0500 Completed number of subjects by teachers using sql Diffstat:
| A | number-of-unique-subjects-taught-by-each-teacher/number-of-subjects-by-teacher.sql | | | 6 | ++++++ |
1 file changed, 6 insertions(+), 0 deletions(-)
diff --git a/number-of-unique-subjects-taught-by-each-teacher/number-of-subjects-by-teacher.sql b/number-of-unique-subjects-taught-by-each-teacher/number-of-subjects-by-teacher.sql @@ -0,0 +1,6 @@ +--Given a table with rows of the teacher_id, subject, and the department +--return the number of subjects each teacher teaches. + +SELECT Teacher.teacher_id , COUNT(DISTINCT Teacher.subject_id) as cnt +FROM Teacher +GROUP By Teacher.teacher_id