题解 | #异常的邮件概率#
异常的邮件概率
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就可以
OPPO成长空间 539人发布
京东三面373人在聊