project_name,

sum(gas_used) as gas_spent,

sum(tx_fee) as fees,

avg(gas_used) as avg_gas_used,

avg(tx_fee) as avg_tx_fee

from avalanche.core.fact_transactions x

join avalanche.core.fact_decoded_event_logs z on x.tx_hash=z.tx_hash

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

where x.block_timestamp >= CURRENT_DATE - interval '{{period_of_days}} days'

and label_type ='nft'

group by 1

order by 2 desc

limit 10