SQL | SOVESQL 2024 🎄: Day 07. 기증품 비율 계산하기

Day 07. 기증품 비율 계산하기

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

WITH T1 AS (
  SELECT artwork_id
    , title
    , LOWER(credit)
    , CASE WHEN LOWER(credit) LIKE '%gift%' THEN artwork_id END AS gift
  FROM artworks
)

SELECT ROUND(COUNT(gift) / COUNT(*)*100,3) AS ratio
FROM T1

❗ROUND() 사용해서 출력 포맷 맞추기

 

 

 

+) WITH 절

❗LOWER() 사용해서 소문자로 바꾸기
❗CASE WHEN, LIKE 사용해서 소문자 credit 중에 gift 찾아 새로운 열 만들기