[SQL]Excel Pivot table at SQL(ex. solvesql 지역별 주문의 특징)

select
  store_id,
  count(
    case
      when active = 1 then customer_id
      else null
    end
  ) as active,
  count(
    case
      when active = 0 then customer_id
      else null
    end
  ) as inactive
from
  customer
group by
  store_id
order by
  store_id

 

solvesql 지역별 주문의 특징

select Region as 'Region', 
    count(distinct case when category ='Furniture' then order_id else null end) as Furniture, 
    count(distinct case when category ='Office Supplies' then order_id else null end) as 'Office Supplies',
    count(distinct case when category ='Technology' then order_id else null end) as Technology
from records
group by region 
order by region

<!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}-->

쿼리 결과 

Region	Furniture	Office Supplies	Technology
Central	124	314	108
East	156	354	158
South	89	204	83
West	195	400	177

https://solvesql.com/problems/characteristics-of-orders/

solvesql