count(distinct(tx_id)) as txn_num,

count(distinct(player)) as players_num,

(txn_num / players_num) as txn_per_player,

sum(price) as total_price,

avg(price) as avg_price_per_txn,

(total_price / players_num) as price_per_player,

median(price) as median_price,

max(price) as max_price,

min(price) as min_price

from flow.core.dim_allday_metadata

left join flow.core.ez_nft_sales

using (nft_id)

where player not in ('N/A', '')

and nft_collection = 'A.e4cf4bdc1751c65d.AllDay'