with buyer_min_dates as (
select
buyer,
min(date(block_timestamp)) as min_day
from
flow.core.ez_nft_sales
where
NFT_COLLECTION like '%RaceDay%'
group by
buyer
), daily as (
select
min_day,
count(*) as cnt
from
buyer_min_dates
group by
min_day
)
select
avg(cnt) as "Average Number of Daily New Buyers"
from
daily