with day_tx as (select BLOCK_TIMESTAMP::date date,count(distinct SENDER) tx
from flipside_prod_db.algorand.application_call_transaction
where 1=1
and TX_TYPE_NAME='application call'
and BLOCK_TIMESTAMP::date between '2021-07-01' and '2021-12-31'
group by 1)
select avg(tx) avg_tx_per_day from day_tx