题目
select *
from cinema
where description!='boring' AND id&1
order by rating DESC
1.查询奇偶数
奇数
select * from table where id&1 ;
偶数
select * from table where id=(id>>1)<<1
https://blog.youkuaiyun.com/linshichen/article/details/51702151
2.排序
升序
select * from table order by rating ASE
降序
select * from table order by rating DESC