SQL
2024. 7. 31.
[MySQL] Leetcode - 1280. Students and Examinations
https://leetcode.com/problems/students-and-examinations/description/?envType=study-plan-v2&envId=top-sql-50문제Write a solution to find the number of times each student attended each exam. Return the result table ordered by student_id and subject_name. The result format is in the following example. - 각 student의 각 시험을 응시한 횟수 구하기예시1Input: Students table:+------------+--------------+| student_id | st..
![[MySQL] Leetcode - 1280. Students and Examinations](http://i1.daumcdn.net/thumb/C450x300/?fname=https://blog.kakaocdn.net/dn/cy8YGz/btsITC8DvKD/wJOvYmQfSAMRdJXA5WDAS0/img.png)