Leetcode 620. Not Boring Movies

考察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
;

 

上一篇:Leetcode- 620. 有趣的电影


下一篇:Android:Logcat中找不到本应该输出的Log调试信息