-
Notifications
You must be signed in to change notification settings - Fork 0
/
620-not_boring_movies.sql
27 lines (23 loc) · 1.29 KB
/
620-not_boring_movies.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
-- 620. Not Boring Movies
-- X city opened a new cinema, many people would like to go to this cinema. The cinema also gives out a poster indicating the movies’ ratings and descriptions.
-- Please write a SQL query to output movies with an odd numbered ID and a description that is not 'boring'. Order the result by rating.
-- For example, table cinema:
-- +---------+-----------+--------------+-----------+
-- | id | movie | description | rating |
-- +---------+-----------+--------------+-----------+
-- | 1 | War | great 3D | 8.9 |
-- | 2 | Science | fiction | 8.5 |
-- | 3 | irish | boring | 6.2 |
-- | 4 | Ice song | Fantacy | 8.6 |
-- | 5 | House card| Interesting| 9.1 |
-- +---------+-----------+--------------+-----------+
-- For the example above, the output should be:
-- +---------+-----------+--------------+-----------+
-- | id | movie | description | rating |
-- +---------+-----------+--------------+-----------+
-- | 5 | House card| Interesting| 9.1 |
-- | 1 | War | great 3D | 8.9 |
-- +---------+-----------+--------------+-----------+
SELECT * FROM cinema
WHERE Mod(id, 2)<> 0 and NOT description = "boring"
ORDER BY rating DESC;