player,

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

where player != 'N/A'

and block_timestamp::date >= current_date - interval '2 weeks'

group by player

order by total_sales_price desc