题解 | #异常的邮件概率#
异常的邮件概率
https://www.nowcoder.com/practice/d6dd656483b545159d3aa89b4c26004e
select date, round(sum(if(e1.type = "no_completed",1,0)) / count(e1.type),3) from email e1 left join user b1 on e1.send_id = b1.id left join user b2 on e1.receive_id = b2.id where b1.is_blacklist = 0 and b2.is_blacklist = 0 group by date order by date;
查看13道真题和解析
上海得物信息集团有限公司公司福利 1125人发布
