题解 | #异常的邮件概率#

异常的邮件概率

https://www.nowcoder.com/practice/d6dd656483b545159d3aa89b4c26004e

SELECT f1.date, CONVERT(IFNULL(f2.fail_num / COUNT(1),0.000), DECIMAL(4,3)) AS P
FROM email AS f1
	LEFT JOIN (SELECT date, COUNT(1) AS fail_num
	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)
		AND type = 'no_completed'
	GROUP BY date) AS f2 ON f1.date = f2.date
WHERE 
	f1.send_id IN (SELECT id FROM user WHERE is_blacklist = 0)
	AND f1.receive_id IN (SELECT id FROM user WHERE is_blacklist = 0)
GROUP BY f1.date;

全部评论

相关推荐

练习生懒羊羊:开飞机把这个公司创飞吧
点赞 评论 收藏
分享
代码飞升:别用口语,后端就写后端,前端就写前端,最后别光后悔
点赞 评论 收藏
分享
星辰再现:裁员给校招生腾地方
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务