1 题目描述
2 解题思路
先筛条件,再进行排序
SELECT id,movie, description, rating
FROM cinema
WHERE description <> 'boring'
AND id%2=1
ORDER BY rating DESC
先筛条件,再进行排序
SELECT id,movie, description, rating
FROM cinema
WHERE description <> 'boring'
AND id%2=1
ORDER BY rating DESC