620. 有趣的电影

https://leetcode-cn.com/problems/not-boring-movies/

MySQL

# Write your MySQL query statement below
SELECT id, movie, description, rating
FROM cinema
WHERE id & 1
AND description <> 'boring'
ORDER BY rating DESC

SQLServer

/* Write your T-SQL query statement below */
SELECT id, movie, description, rating
FROM cinema
WHERE id % 2 = 1 AND description NOT LIKE '%boring%'
ORDER by 4 DESC