Leetcode刷题119-620. 有趣的电影(MySQL解法！！！)

最新推荐文章于 2022-09-07 17:07:09 发布

huyunceng_cloud

最新推荐文章于 2022-09-07 17:07:09 发布

阅读量188

点赞数

分类专栏： LeetCode从零开始文章标签： LeetCode

本文链接：https://blog.csdn.net/qq_40858438/article/details/95230167

版权

LeetCode从零开始专栏收录该内容

95 篇文章 3 订阅

订阅专栏

Come from : [https://leetcode-cn.com/problems/not-boring-movies/]

1.Question

SQL架构
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     |
+---------+-----------+--------------+-----------+

2.Answer

easy 类型题目。简单的SQL语句查询（不多BB）.

AC代码如下（Oracle ORA-00911: invalid character不懂为什么）：

# Write your MySQL query statement below
select id, movie, description,rating from cinema
where description !='boring' and id%2!=0  //也可以使用 mod(id,2)=1 来确定奇数 id
order by rating desc;