题解 | #异常的邮件概率#
异常的邮件概率
https://www.nowcoder.com/practice/d6dd656483b545159d3aa89b4c26004e
SELECT date, ROUND(AVG(CASE WHEN type LIKE 'no_completed' THEN 1 ELSE 0 END),3) AS p 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 ORDER BY date ASC;
算概率直接用AVG+case when就可以
哔哩哔哩公司氛围 723人发布
查看9道真题和解析