Event_name as "Events",

count(distinct l.tx_hash) as "Total TXN",

count(distinct ORIGIN_FROM_ADDRESS) as "Total users",

count(distinct NFT_TO_ADDRESS) as "Total minters",

count(distinct TOKENID) as "Minted NFTs",

count(distinct project_name) as "Projects",

"Total users"/count(distinct date_trunc(day, l.block_timestamp)) as "Average user per day",

"Total minters"/count(distinct date_trunc(day, l.block_timestamp)) as "Average minter per day",

"Total TXN"/"Total minters" as "Average mints per minter"

from avalanche.core.ez_decoded_event_logs l

left join avalanche.core.ez_nft_transfers a on l.tx_hash=a.tx_hash

where contract_address='0x13d8c4e3741e968cc8e740bdb02537cb1d2d70e6'

group by 1