count (distinct x.tx_hash) as "Number of txns",

sum(tx_fee) as "Total fees",

avg(tx_fee) as "Average fee per txn",

median(tx_fee) as "Median of fees",

min(tx_fee) as "Min of fee",

max(tx_fee) as "Max of fee"

from avalanche.core.fact_transactions x join avalanche.core.fact_event_logs y on x.tx_hash = y.tx_hash

join avalanche.core.dim_contracts z on y.contract_address = z.address

where x.block_timestamp >= '{{From_Date}}'

and x.block_timestamp <= '{{To_Date}}'