728x90
< 문제 >
[SQL50] 620. Not Boring Movies (AGGREGATE)
< 풀이 >
SELECT *
FROM Cinema
WHERE description != 'boring' AND id % 2 != 0
ORDER BY rating DESC;
728x90
'coding_test > SQL 문제' 카테고리의 다른 글
| [LeetCode] 1075. Project Employees I (AGGREGATE) (0) | 2025.02.10 |
|---|---|
| [LeetCode] 1251. Average Selling Price (AGGREGATE) (0) | 2025.02.10 |
| [LeetCode] 1934. Confirmation Rate (JOIN) (0) | 2025.02.08 |
| [LeetCode] 570. Managers with at Least 5 Direct Reports (JOIN) (0) | 2025.02.08 |
| [LeetCode] 1280. Students and Examinations (JOIN) (0) | 2025.02.08 |