select

project_name,

count (distinct tx_hash) as mint_txns,

sum(tx_fee) as tot_fee,

row_number()over(order by tot_fee ) as n

from

ethereum.core.ez_nft_mints

where block_timestamp >= '2022-01-01' and PROJECT_NAME is not null

group by project_name

order by 3 desc limit 20