leetcode

0 SELECT S.student_id, S.student_name, C.subject_name, COUNT(E.student_id) AS attended_exams

1 FROM Students S

2 CROSS JOIN Subjects C

3 LEFT JOIN Examinations E

4 ON S.student_id = E.student_id AND

5 C.subject_name = E.subject_name

6 GROUP BY S.student_id, C.subject_name

7 ORDER BY S.student_id, C.subject_name

8