distinct (a.player) as player,

count(*) as tx_num,

sum(price) as price_sum,

avg(price) as price_avg

from flow.core.dim_allday_metadata a

left join flow.core.ez_nft_sales b

using (nft_id)

where player not like 'N/A'

group by player

order by price_sum desc, price_avg desc, tx_num desc

limit 10