with tab1 as (select block_timestamp::date as date, count(distinct tx_hash) as txns_count
from aurora.core.fact_transactions
where block_timestamp::date>='{{Start_Date}}' and block_timestamp::date<='{{End_Date}}'
and status<>'Series 3'
group by 1)
select round(avg(txns_count)) as avg_txn, median(txns_count) as median_txn
from tab1