avg(price)

from flow.core.ez_nft_sales left outer join flow.core.dim_allday_metadata

on flow.core.ez_nft_sales.nft_id = flow.core.dim_allday_metadata.nft_id

where team is not null