https://leetcode.com/problems/not-boring-movies/description/
SELECT *
FROM cinema
WHERE description <> 'boring'
AND MOD(id, 2) = 1
ORDER BY rating DESC
느낀 점 및 정리 ✍️
1. odd-numbered ID => MOD(id, 2) = 1
2. description that is not boring => <> 'boring'
3. ordered by rating in descending order => ORDER BY rating DESC
'Algorithm & SQL > LeetCode' 카테고리의 다른 글
| [LeetCode 181번 / MySQL] 181 : Employees Earning More Than Their Managers (0) | 2024.03.10 |
|---|---|
| [LeetCode 183번 / MySQL] 183 : Customers Who Never Order (0) | 2024.03.10 |
| [LeetCode 1179번 / MySQL] 1179 : Reformat Department Table (0) | 2024.03.10 |
| [LeetCode 182번 / MySQL] 182 : Duplicate Emails (0) | 2024.03.10 |
| [LeetCode 595번 / MySQL] 595 : Big Countries (0) | 2024.03.10 |
