最直接的思考方式 select t1.date, round(t1.col1/t2.col2,3) as p from( select date,count(1) col1 from email where send_id not in (select id from user where is_blacklist = 1) and receive_id not in (select id from user where is_blacklist = 1) and type = 'no_completed' group by date) t1 join (select date,count(1...