题目:
编写一段 SQL 来查找:在被报告为垃圾广告的帖子中,被移除的帖子的每日平均占比,四舍五入到小数点后 2 位
结果表:
答案:
SELECT ROUND(AVG(percent) * 100,2) AS average_daily_percent
FROM
(SELECT SUM(IF(tag = 'Y',1,0))/COUNT(post_id) AS percent
FROM
(SELECT DISTINCT post_id,
action_date,
CASE WHEN post_id IN (SELE