select date_trunc('day', block_timestamp) as day,

case

when day >= '2022-06-01 00:00:00.000' then 'Second Half of 2022'

else 'First Half of 2022'

end as period,

count(tx_id)/1440 as Transactions_Per_minutes

from flow.core.fact_transactions

where block_timestamp >= '2022-01-01'

group by 1)

select period,

avg(Transactions_Per_minutes) as avg_tpm

from maintable

group by 1