[SQL문제풀기] 기증품 비율 계산하기

문제

solvesql.com

https://solvesql.com/problems/ratio-of-gifts/

SQLite

내가 작성한 정답

select round(count(artwork_id)*100.0/(select count(artwork_id) from artworks )*1.0,3) ratio
from artworks
where credit like '%gift%';