[leetcode] 620. Not Boring Movies

EVEN NUMBER : 짝수

ODD NUMBER : 홀수

 

테이블 생성코드

Create table If Not Exists cinema (id int, movie varchar(255), description varchar(255), rating float(2, 1))

Truncate table cinema

insert into cinema (id, movie, description, rating) values ('1', 'War', 'great 3D', '8.9')

insert into cinema (id, movie, description, rating) values ('2', 'Science', 'fiction', '8.5')

insert into cinema (id, movie, description, rating) values ('3', 'irish', 'boring', '6.2')

insert into cinema (id, movie, description, rating) values ('4', 'Ice song', 'Fantacy', '8.6')

insert into cinema (id, movie, description, rating) values ('5', 'House card', 'Interesting', '9.1')

 

 

문제

 

 

해결 코드

# Write your MySQL query statement below

SELECT id,movie,description,rating

FROM cinema

WHERE (ID%2)=1 AND description NOT IN ('boring')

ORDER BY rating DESC;

 

 

해설

ODD NUMBER 는 홀수 이므로 %해서 나온 숫자가 1인것을 출력하고
description이 boring인것을 빼자라고 생각했습니다.

따라서 WHERE (ID%2)=1 AND description NOT IN ('boring') 를 입력해주었고

ORDER BY에서 rating 으로 내림차순 정렬 해주었습니다.