SELECT

tx_id

FROM flow.core.fact_events

WHERE event_contract LIKE '%BBxBarbiePack%'

AND event_type = 'Mint'

AND tx_succeeded = 'true'

),

minters AS (

SELECT

MIN(block_timestamp) AS date,

event_data:to minter,

COUNT(DISTINCT event_data:id) AS NFTs

FROM flow.core.fact_events

JOIN mints USING (tx_id)

WHERE event_type = 'Deposit'

GROUP BY 2

SELECT

CASE

WHEN NFTs = 1 THEN '1 NFT'

WHEN NFTs = 2 THEN '2 NFTs'

WHEN NFTs = 3 THEN '3 NFTs'

WHEN NFTs = 4 THEN '4 NFTs'

WHEN NFTs = 5 THEN '5 NFTs'

WHEN NFTs = 6 THEN '6 NFTs'

ELSE 'More Than 6 NFTs'

END AS type,

COUNT(DISTINCT minter) AS minters

FROM minters

GROUP BY 1

ORDER BY 1;