题目 :https://leetcode.cn/problems/not-boring-movies/
数据
Create table If Not Exists cinema (
id int,
movie varchar(255),
description varchar(255),
rating float(2, 1)
)
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')
需求
查询所有影片描述为非 boring (不无聊) ,并 id 为奇数 的影片,结果请按等级 rating 排列
查询结果 :
| id | movie | description | rating |
| 5 | House card| Interesting| 9.1 |
| 1 | War | great 3D | 8.9 |
解决
例子 :
- 8 : 1000 & 1 = 0
- 7 : 0111 & 1 = 1
select *
from cinema
where description != 'boring' and (id & 1 = 1)
order by rating desc;