[SQL문제풀기] Spam Posts

문제

StrataScratch - Spam Posts

StrataScratch

https://platform.stratascratch.com/coding/10134-spam-posts?code_type=7

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select p.post_date,
        count(distinct case when p.post_keywords like '%spam%' then p.post_id end)*100.00/ count(distinct p.post_id) spam_share
from facebook_posts p
join facebook_post_views v
on p.post_id = v.post_id and v.viewer_id is not null
group by post_date