with t1 as (select NFT_ID as a,SERIAL_NUMBER,PLAYER,TEAM,PLAY_TYPE
from flow.core.dim_allday_metadata)
select sum(PRICE) AS volume ,count(distinct(NFT_ID)) as "number of uniqe NFT group by play type",avg(price) as average_price,max(price) as maximum_price,
PLAY_TYPE 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 5
order by 3 desc