샘플 데이터의 무료를 현금으로 바꿨습니다~

with t as (
select 1 id, 1 store_id, '신용카드' purchase_type, 1000 price union all
select 2 id, 1 store_id, '신용카드' purchase_type, 500 price union all
select 3 id, 1 store_id, '현금' purchase_type, 1000 price union all
select 4 id, 1 store_id, '현금' purchase_type, 10000 price union all
select 5 id, 1 store_id, '쿠폰' purchase_type, 500 price
)
select store_id 매장,
       sum(case when purchase_type ='신용카드' then price else 0 end) 신용카드별_합계,
       sum(case when purchase_type ='현금' then price else 0 end) 현금결제별_합계,
       sum(case when purchase_type ='무료' then price else 0 end) 무료결제별_합계,
       sum(case when purchase_type ='쿠폰' then price else 0 end) 쿠폰별_합계
 from t
group by store_id