with total_txns as (
select
-- date_trunc('week', block_timestamp) as week,
case when block_timestamp >= '2023-01-01' then '2023'
else '2022'
END as category,
sum(fee) as volume
-- count(*) as total_count
from terra.core.fact_transactions
where block_timestamp > current_date - 90
group by 1
-- order by week desc
)
select * from total_txns