参考答案:
select * from cinema where description != 'boring' and mod(id,2) = 1 order by rating desc
知识点补充:
奇数:mod(id,2)=1
偶数:mod(id,2)=0
排序:order by 列名 desc 倒叙 order by 列名 asc 正序
参考答案:
select * from cinema where description != 'boring' and mod(id,2) = 1 order by rating desc
知识点补充:
奇数:mod(id,2)=1
偶数:mod(id,2)=0
排序:order by 列名 desc 倒叙 order by 列名 asc 正序