LABEL AS "collection",

count(distinct tx_hash) as "transactions",

count(distinct tokenid) as "nfts",

count(distinct buyer_address) as "buyers",

count(distinct seller_address) as "sellers",

count(tokenid)/"transactions" as "count nft per tx",

sum(price) as "volume",

sum(price_usd) as "volume_usd",

avg(price_usd) as "price",

SUM(CREATOR_FEE_USD) as "Royalty",

AVG(CREATOR_FEE_USD) as "Average Royalty",

DIV0("Royalty" , "volume_usd") * 100 as "Average Royalty Percentage"

from ethereum.core.ez_nft_sales tb1 join ethereum.core.dim_labels tb2 on tb1.NFT_ADDRESS=tb2.ADDRESS

where ORIGIN_TO_ADDRESS = lower('0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b')

and ORIGIN_FUNCTION_SIGNATURE = lower('0x24856bc3')

and EVENT_TYPE = 'sale'

group by 1

order by "buyers" desc

limit 5