考察SQL query的写法.
格式如下:
SELECT...
FROM..
WHERE...
ORDER BY ...;
注意where中判断两个数相等,写一个等号而不是两个.
# Write your MySQL query statement below select id,movie,description,rating from cinema where id%2=1 and description!='boring' order by rating desc ;
2023-11-20 16:59:27
考察SQL query的写法.
格式如下:
SELECT...
FROM..
WHERE...
ORDER BY ...;
注意where中判断两个数相等,写一个等号而不是两个.
# Write your MySQL query statement below select id,movie,description,rating from cinema where id%2=1 and description!='boring' order by rating desc ;