select avg("application calls") as "average application calls per block" from
(select count(*) as "application calls", BLOCK_ID from flipside_prod_db.algorand.application_call_transaction
where BLOCK_TIMESTAMP between '2021-06-01' and '2021-12-31'
group by 2)