from flow.core.dim_allday_metadata),

t2 as

(select sum(price) as maximum_price

from t1 a inner join flow.core.ez_nft_sales b

on a.a=b.NFT_ID

where NFT_COLLECTION='A.e4cf4bdc1751c65d.AllDay' and PLAY_TYPE in('Reception','Pass','Player Melt','Team Melt','Pressure')),

t3 as (select NFT_ID as a,SERIAL_NUMBER,PLAYER,TEAM,PLAY_TYPE

from flow.core.dim_allday_metadata),

t4 as

(select MAX(price) AS "MAX pice", sum(PRICE) AS price ,count(distinct(NFT_ID)) as "Number of NFT related to this player", PLAYER from t3 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 2 desc

limit 50)

select x/MAXIMUM_PRICE as "volume ratio" from (select sum(price) as x from t4) full join t2