leetcode

Solution to some Leetcode problems written in C++

git clone git://git.dimitrijedobrota.com/leetcode.git

1280.sql (301B)

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