LeetCode / 1204. Last Person to Fit in the Bus / MySQL(Medium)
2023. 12. 6. 12:24
📚문제 📝풀이 SELECT person_name FROM Queue WHERE turn = (SELECT MAX(turn) AS turn FROM (SELECT q1.turn , SUM(q2.weight) AS total_weight FROM Queue q1 INNER JOIN Queue q2 ON q1.turn >= q2.turn GROUP BY q1.turn HAVING total_weight = q2.turn ORDER BY q1.turn; 왼쪽테이블(q1)의 turn으로 그룹화하면 오른쪽테이블은 q1의 turn에 대해 작거나 같은 turn들이 정렬 된다 2. SUM(q2.weight) SELECT q1.turn , SUM(q2.weight) AS total_weight FROM Queue q1 I..
