[leetcode]620. Not Boring Movies
来源:互联网 发布:mac装win8还是win10 编辑:程序博客网 时间:2024/05/29 08:35
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 |+---------+-----------+--------------+-----------+
Solution:
# Write your MySQL query statement below
select * from cinema where description !='boring' and id%2!=0 order by rating desc
阅读全文
1 0
- [leetcode]620. Not Boring Movies
- [LeetCode] 620.Not Boring Movies
- sql leetcode 620. Not Boring Movies
- 620. Not Boring Movies
- 620. Not Boring Movies
- 620.Not Boring Movies
- 620. Not Boring Movies
- leetcode 620. Not Boring Movies(SQL,查询排序)38
- 620. Not Boring Movies--MOD()取余
- leetcode620. Not Boring Movies
- 17.leetCode620:Not Boring Movies
- movies
- Making Your ActionBar Not Boring
- Making Your ActionBar Not Boring
- Making Your ActionBar Not Boring
- Boring
- Boring
- boring
- 联想小新固态硬盘安装Win7过程
- python实现顺序查找和折半查找
- 链表结构有关的算法
- linux中的工作排程
- js数字转换总结
- [leetcode]620. Not Boring Movies
- Mysql技术内幕InnoDB存储引擎读书笔记--《七》事务
- 七、模板方法模式——设计模式学习笔记
- 对tomcat来说,每一个进来的请求(request)都需要一个线程,直到该请求结束。
- Vue 2.0 高级实战-开发移动端音乐WebApp
- AVA反射(1)
- MinGW在Windows上的安装和环境配置
- HTML基础--基础标签 02
- Linux虚拟机下安装 JDK 和 Tomcat