[LeetCode] 620.Not Boring Movies

[LeetCode] 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

解题思路

SQL第三弹，说实话博主不怎么清楚SQL具体语句，去年学过的数据库方面的知识忘得差不多了哈哈哈。所以不知道写出来是否符合标准，不过确实是AC了，凭回忆写的。这道题注意三个条件：
1. 选择出来的id要为奇数； （id % 2 = 1）
2. description不能为boring； （description <> ‘boring’）
3. 选择出来的数据按rating倒序排序。 （ORDER BY rating DESC）
具体见代码。

实验代码

# Write your MySQL query statement below
SELECT * FROM cinema 
    WHERE (description <> 'boring') AND (id % 2 = 1) 
    ORDER BY rating DESC