count (distinct tx_id) as no_of_txns,

round(no_of_txns/(24*60),2) as txns_per_min,

round(no_of_txns/(24*60*60),2) as txns_per_sec

from flow.core.fact_events

where block_timestamp >= '2022-01-01'

group by 1

order by 2 DESC