play_type,

sum(price) as total_sales_price,

avg(price) as average_sales_price,

median(price) as median_sales_price,

count(distinct(tx_id)) as tx_num

from flow.core.dim_allday_metadata a join flow.core.ez_nft_sales b

on a.nft_id = b.nft_id

group by play_type

order by total_sales_price desc