leetcode 620. Not Boring Movies(SQL,查询排序)38

xiaoxiao2021-02-28  26

贴原题:

解析:   本题是要用从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;
转载请注明原文地址: https://www.6miu.com/read-1700272.html

最新回复(0)