LeetCode/릿코드-Not Boring Movies-MySQL

문제

풀이

• write an sql query to report the movies with an odd-numbered id and a description that is not boring
• return the result table in descending order by rating.
• the query result format is in the following example

쿼리

-- leetcode, Not Boring Movies, mysql
SELECT *
FROM Cinema
WHERE id%2 = 1 AND description != 'boring'
ORDER BY rating DESC

결과

출처 && 깃허브

leetcode
github