nose딩

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

*컬럼명 공백 포함하고 싶을때는 '' 이용