with final_data as (
select to_date(block_timestamp) as date,
count(*) as total_count,
count(distinct tx_sender) as senders_count,
'Before Week Situation' from terra.core.fact_transactions
where year(block_timestamp)=2023 and date >='2023-01-07' and date <='2023-01-13'
group by date
UNION
select to_date(block_timestamp) as date,
count(*) as total_count,
count(distinct tx_sender) as senders_count, 'After Week Situation' from terra.core.fact_transactions
where year(block_timestamp)=2023 and
date >='2023-01-15' and date <='2023-01-21'
group by date
)
select * from final_data