[데이터분석] 코드카타 91

https://leetcode.com/problems/not-boring-movies/description/

 

91. Not Boring Movies

 

Write a solution to report the movies with an odd-numbered ID and a description that is not "boring".

Return the result table ordered by rating in descending order.

 

select *

from Cinema

where mod(id,2)=1 and description <> 'boring'

order by rating desc