我稍微修改了一下代码，可以在sqlite里面跑了，效率的确不高 select date ,round(cast(count(case when type = 'no_completed' then 1 else null end) as double)/count(id),3) as p from email where send_id in (select id from user where is_blacklist = 0) and receive_id in (select id from user where is_blacklist = 0) group by date;