WITH
TuneGONFT AS (
SELECT
buyer,
MIN(block_timestamp) AS mindate
FROM
flow.core.ez_nft_sales s
WHERE
nft_collection = 'A.c6945445cdbefec9.TuneGONFT'
AND tx_succeeded = 'TRUE'
GROUP BY
buyer
),
allt1 AS (
SELECT
buyer,
MIN(block_timestamp) AS mindate
FROM
flow.core.ez_nft_sales s
WHERE
tx_succeeded = 'TRUE'
GROUP BY
buyer
),
finaltable AS (
SELECT
COUNT(DISTINCT t1.buyer) AS buyerss
FROM
allt1 t1
JOIN TuneGONFT t2 ON t1.buyer = t2.buyer
AND t1.mindate = t2.mindate
),
ftable AS (
SELECT
buyerss,
(