题解 | 异常的邮件概率
异常的邮件概率
https://www.nowcoder.com/practice/d6dd656483b545159d3aa89b4c26004e
select date, round(avg(if(type='no_completed',1,0)),3) as p from email as a 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 order by date;
投递字节跳动等公司10个岗位 >