题解 | #异常的邮件概率#

SELECT y.date,round(no_com/total,3) as P
FROM (SELECT `date`,count(*) as no_com
FROM email
WHERE type='no_completed' AND 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`) y,
(SELECT `date`,count(*) as total
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`) t 
WHERE y.date=t.date