select BLOCK_TIMESTAMP::date as day,count(distinct TX_HASH) as total_success_daily_transaction

from polygon.core.fact_transactions

where BLOCK_TIMESTAMP::date>='2022-07-1' and STATUS='SUCCESS'

group by day

order by day

select sum (total_success_daily_transaction) as Total_success_transactions, avg(total_success_daily_transaction) average_sucess_transactions

from daily