分析:需要从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;
提交结果为: