10 lines
339 B
SQL
10 lines
339 B
SQL
{%- set payment_methods = ["bank_transfer", "credit_card", "gift_card"] -%}
|
|
|
|
select
|
|
order_id,
|
|
{%- for payment_method in payment_methods %}
|
|
sum(case when payment_method = '{{payment_method}}' then amount end) as {{payment_method}}_amount
|
|
{%- if not loop.last %},{% endif -%}
|
|
{% endfor %}
|
|
from {{ ref('raw_payments') }}
|
|
group by 1
|