LeetCode 620. Not Boring Movies (有趣的电影)
题目标签:
题目给了我们一个 cinema 表格, 让我们找出 不无聊的电影,并且id 是奇数的,降序排列。
比较直接简单的,具体看code。
Java Solution:
Runtime: 149 ms, faster than 29.21%
Memory Usage: N/A
完成日期:07/02/2019
关键点:NOT IN
# Write your MySQL query statement below SELECT id, movie, description, rating FROM cinema WHERE id % 2 != 0 AND description NOT IN ("boring") ORDER BY rating DESC;
LeetCode 题目列表 - LeetCode Questions List
题目来源:https://leetcode.com/