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

最新推荐文章于 2025-01-21 21:04:43 发布

huyunceng_cloud

最新推荐文章于 2025-01-21 21:04:43 发布

阅读量224

点赞数

CC 4.0 BY-SA版权

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

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

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

95 篇文章

订阅专栏

博客来自LeetCode题目，给出SQL架构，要求查询ID为奇数且描述非‘boring’的电影并按评分排序。作者认为是简单SQL查询，给出AC代码，还提到遇到Oracle报错问题，最后分享了自己的收获。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;