[SQL문제풀기] Meta/Facebook Accounts

문제

StrataScratch - Meta/Facebook Accounts

StrataScratch

https://platform.stratascratch.com/coding/10296-facebook-accounts?code_type=3

내가 작성한 오답

select count(case when status = 'closed' then 1 end )*1.00/ count(acc_id) closed_ratio
from fb_account_status
where (acc_id,status_date) in (select acc_id, max(status_date)
                                from fb_account_status
                                where date(status_date) <= '2020-01-10'
                                group by acc_id);

내가 작성한 정답

MySQL, PostgreSQL

select count(case when status = 'closed' then 1 end )*1.00/ count(acc_id) closed_ratio
from fb_account_status
where date(status_date) = '2020-01-10';

Oracle

select count(case when status = 'closed' then 1 end )*1.00/ count(acc_id) closed_ratio
from fb_account_status
where to_char(status_date,'yyyy-mm-dd') = '2020-01-10';