select date_trunc(day, block_timestamp) as date,
count(distinct block_id) as num_of_blocks,
count(tx_id) as num_of_tx,
num_of_tx/num_of_blocks as avg_tx_per_block
from flipside_prod_db.algorand.application_call_transaction
where tx_type_name = 'application call'
AND date BETWEEN '2021-07-02 00:00:00.000' AND '2022-07-02 00:00:00.000'
group by date
order by date asc