SELECT block_id, block_timestamp, COUNT(tx_id) AS tx_count

FROM flipside_prod_db.algorand.application_call_transaction

WHERE block_timestamp > '2021-07-01'

GROUP BY block_id, block_timestamp

SELECT avg(tx_count) as "Average tx/block",

CASE WHEN block_timestamp < '2022-01-01' THEN 'Last 6 months of 2021'

ELSE 'First 6 months of 2022' END AS grp

FROM blocks

GROUP BY grp