본문 바로가기

FROM절

LeetCode / 1341. Movie Rating / MySQL(Medium) / Subquery 2023. 12. 12. 10:31 📚문제 📝풀이 # Write your MySQL query statement below SELECT MIN(result) AS results FROM ( SELECT u.name AS result FROM MovieRating r INNER JOIN Users u ON r.user_id = u.user_id GROUP BY u.name ORDER BY COUNT(*) DESC, u.name LIMIT 1) AS names UNION ALL SELECT MIN(result) AS results FROM ( SELECT m.title AS result FROM MovieRating r INNER JOIN Movies m ON r.movie_id = m.movie_id WHERE LEFT(created_at,..
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..
LeetCode 2356. Number of Unique Subjects Taught by Each Teacher / MySQL / Easy (From절 서브쿼리) 2023. 11. 30. 16:45 📚문제 📝풀이 # Write your MySQL query statement below SELECT teacher_id , COUNT(subject_id) AS cnt FROM (SELECT teacher_id,subject_id,COUNT(*) FROM Teacher GROUP BY teacher_id,subject_id) AS teacher_grouping GROUP BY teacher_id FROM 절 서브쿼리를 활용하여 풀이

티스토리툴바