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

select

count(player) as players_num,

max(tx_num) as max_tx_num,

min(tx_num) as min_tx_num,

avg(tx_num) as average_tx_num_per_player,

max(price_sum) as max_price,

min(price_sum) as min_price,

avg(price_sum) as average_price_per_player

from players