題目：
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 |
+———+———–+————–+———–+

題意：查詢cinema表中id為奇數(shù)且description不為boring的電影，并將結(jié)果按rating從大到小進(jìn)行排序。

代碼：

select * from cinema where mod(id,2)=1 and description != 'boring' order by rating desc

判斷一個(gè)數(shù)是否為奇數(shù)的方法：
1.mod(id,2)=1
2.id%2<>1 或 id%2！=0

總結(jié)

以上是生活随笔為你收集整理的17.leetCode620:Not Boring Movies的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。