avg(fee/1e9) as avg_fees,

sum(fee/1e9) as total_fees,

count(distinct tx_id) as tx

from solana.core.fact_transactions

where date(block_timestamp) >= current_date - 8 and succeeded = 'false'

group by 1