题解 | 异常的邮件概率
select e.date ,round(1-sum(case e.type when 'completed' then 1 else 0 end)*1.0/count(*),3) as p from email e 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 e.date order by e.date
阿里巴巴灵犀互娱公司氛围 78人发布
查看2道真题和解析