LeetCode / 1280. Students and Examinations / MySQL(Easy)
2023. 11. 24. 12:48
📚문제 📝풀이 # Write your MySQL query statement below SELECT s.student_id , s.student_name , j.subject_name ,COUNT(e.student_id) AS attended_exams FROM Students s INNER JOIN Subjects j LEFT JOIN Examinations e ON s.student_id = e.student_id AND j.subject_name = e.subject_name GROUP BY s.student_id,s.student_name,j.subject_name ORDER BY s.student_id,j.subject_name 테이블 3개를 어떻게 조인해주어야하는지 고민을 많이했다 Examin..
