贴原题:
解析:
本题是要用从ciema表中选出id为奇数,并且description不为’boring’的电影,并按照rating降序排序输出。
贴SQL代码:
# Write your MySQL query statement below
SELECT *
FROM cinema
WHERE id%2=1 AND description!='boring'
ORDER BY rating DESC;
贴原题:
解析:
本题是要用从ciema表中选出id为奇数,并且description不为’boring’的电影,并按照rating降序排序输出。
贴SQL代码:
# Write your MySQL query statement below
SELECT *
FROM cinema
WHERE id%2=1 AND description!='boring'
ORDER BY rating DESC;