#SQL rollup example

rollup_example.sql

with
    tt1 as (
        select *
        from
            (values
                 (1, 'USD', 'website', 10),
                 (2, 'USD', 'website', 11),
                 (3, 'EUR', 'website', 24),
                 (4, 'EUR', 'domain' , 14),
                 (5, 'EUR', 'domain' , 74),
                 (6, 'GBP', 'domain', 105)
                 ) x (id, tcy, product, amount)
    )
select
    coalesce(tcy,'total'),
    coalesce(product,'total'),
    sum(tt1.amount) sum_amount
from
    tt1
GROUP BY rollup (product, (tcy, product))
;