MOMENT_TIER,

avg(price),

count(*) as sales

FROM flow.core.ez_nft_sales

LEFT outer JOIN flow.core.dim_allday_metadata

ON flow.core.dim_allday_metadata.nft_id = flow.core.ez_nft_sales.nft_id

WHERE flow.core.ez_nft_sales.nft_collection LIKE '%AllDay'

AND MOMENT_STATS_FULL:metadata:playerPosition LIKE '{{primary_position}}'

GROUP BY 1