from flow.core.dim_allday_metadata),

t2 as

(select sum(PRICE) AS seals_volume,max(PRICE) as "Maximum seals price" ,count(distinct(NFT_ID)) as "Number of NFT related to this player", PLAYER from t1 a inner join flow.core.ez_nft_sales b

on a.a=b.NFT_ID

where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay'

group by 4

order by 1 desc

limit 50)

,

t3 as

(select sum(seals_volume) as "Total volume of 50 top most volumed player" from t2),

t4 as

(select sum (PRICE) as s from t1 a inner join flow.core.ez_nft_sales b on a.a=b.NFT_ID where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay')

select "Total volume of 50 top most volumed player"*100/s as "Percent of all nft seals volume done by 50 top most volumed player" from t4 inner join t3