leetcode

commit c6c4fcdb710367b2818e34f770d4a91a30cdfa16
parent d10564d2b0a874a39b7397407e5d79dced8fbe64
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Sat,  1 Jul 2023 11:47:30 -0500

Completed student and examinations query problem using mySQL

Diffstat:
A
students-and-examinations/students-and-examintions.sql
 | 
12
++++++++++++

1 file changed, 12 insertions(+), 0 deletions(-)
diff --git a/students-and-examinations/students-and-examintions.sql b/students-and-examinations/students-and-examintions.sql
@@ -0,0 +1,12 @@
+--Given a set of students, exams taken, and exams return
+--the number of times each student has completed each exam (The number of attended_exams me be = 0)
+
+SELECT Students.student_id, Students.student_name, 
+       Subjects.subject_name, COUNT(Examinations.subject_name) as attended_exams
+FROM Students
+CROSS JOIN Subjects
+LEFT JOIN Examinations
+    ON Examinations.subject_name = Subjects.subject_name 
+    AND Examinations.student_id = Students.student_id
+GROUP BY Students.student_id, Students.student_name, Subjects.subject_name
+ORDER BY Students.student_id, Subjects.subject_name