解题思路:
条件连接用where, id 为奇数用mod(id,2)!=0,描述为非 boring
(不无聊)用description!= 'boring',两个条件同时满足用and连接。
select * from cinema where description!= 'boring' and mod(id,2)!=0 order by rating desc;
解题思路:
条件连接用where, id 为奇数用mod(id,2)!=0,描述为非 boring
(不无聊)用description!= 'boring',两个条件同时满足用and连接。
select * from cinema where description!= 'boring' and mod(id,2)!=0 order by rating desc;