97.66%(如果改为id%2=1则变为91.13% ,因此与python一样,若是判断范围更大,则效率会更高)
# Write your MySQL query statement below
select id,movie,description,rating
from cinema
where id%2>0 and description!='boring'
order by rating DESC
——————————————————
mod函数明显效率更低下
41.61%
# Write your MySQL query statement below
select id,movie,description,rating
from cinema
where mod(id,2)=1 and description!='boring'
order by rating DESC
————————————————