leetcode-sql-620有趣的电影

题目如下

分析

需要从cinema表中查找出description不为boring的而且id为奇数的影片，按照rating排列。重点是description不为boring 即description <> boring。id为奇数，即id%2 = 1。按照rating排列，即order by rating desc;

答案

select * from cinema where description <> 'boring' and id%2 = 1 order by rating desc;

提交结果为：