[SQL문제풀기] Find the percentage of shipable orders

문제

StrataScratch - Find the percentage of shipable orders

StrataScratch

https://platform.stratascratch.com/coding/10090-find-the-percentage-of-shipable-orders/official-solution?code_type=7

내가 작성한 정답

MySQL, PostgreSQL, Oracle

select count(case when address is not null then o.id end)*100.00/count(o.id) percent_shipable
from orders o
join customers c
on o.cust_id = c.id;