SQL 코테 준비 (10월 2주)(solvesql-2회)

Об этом предложении

10.5 1) 3년간 들어온 소장품 집계하기 select classification, sum(case when year(acquisition_date) = 2014 then 1 else 0 end) as '2014', sum(case when year(acquisition_date) = 2015 then 1 else 0 end) as '2015', sum(case when year(acquisition_date) = 2016 then 1 else 0 end) as '2016' from artworks group by 1 order by 1 2) 12월 우수 고객 찾기 select customer_id from records where month(order_date) = 12 group by 1 having sum(sales) >= 1000 10.6 1) 스탬프를 찍어드려요 select case when total_bill >= 25 then 2 when total_bill >= 15 then 1 else 0 end as stamp, count(*) as count_bill from tips group by 1 order by 1 2) DVD 대여점 우수 고객 찾기 select customer_id from rental r join customer c using(customer_id) where c.active = 1 group by 1 having count(*) >= 35

Детали предложения

Провайдер

velog

Источник

velog-rss

Балл

54.38

Уверенность

49%