개인 과제#4번 다시 풀어봄WITH a AS ( SELECT order_id ,payment_type ,payment_value FROM spa.payments p WHERE payment_value > (SELECT avg(payment_value) FROM spa.payments p2 WHERE p.payment_type = p2.payment_type)),b AS ( SELECT DISTINCT payment_type, round(sum(payment_value) OVER (PARTITION BY payment_type),2) s FROM spa.payments p)SELECT order_id, a.payment_type ,payment_value , round(a.payment_val..
