SELECT

TOKENID,

min(CASE WHEN nft_from_address = '0x0000000000000000000000000000000000000000' THEN date(block_timestamp) END) as mint_date,

max(CASE WHEN nft_to_address = '0x0000000000000000000000000000000000000000' THEN date(block_timestamp) END) as burn_date,

max(CASE WHEN nft_to_address = '0x0000000000000000000000000000000000000000' THEN 1 else 0 END) as burn_date1

FROM base.nft.ez_nft_transfers

WHERE NFT_address = lower('0x5b51Cf49Cb48617084eF35e7c7d7A21914769ff1')

GROUP BY 1

),

nft_ages AS (

SELECT

TOKENID,

mint_date,

burn_date,

DATEDIFF(day, mint_date, CASE WHEN burn_date1 = 1 THEN CURRENT_DATE ELSE burn_date END) as age_in_days

FROM nft_dates

SELECT

--TOKENID,

date_trunc('week', mint_date) as mint_week,

--burn_date,

--age_in_days,

--CASE

-- WHEN age_in_days < 7 THEN '0-6 days'

-- WHEN age_in_days BETWEEN 7 AND 29 THEN '7-29 days'

-- WHEN age_in_days BETWEEN 30 AND 89 THEN '30-89 days'

-- WHEN age_in_days BETWEEN 90 AND 179 THEN '90-179 days'

-- ELSE '180+ days'

--END as age_range,

case when burn_date1 = 0 then 'alive' else 'dead' end as nft_type,

count(*) as nfts

FROM nft_dates

GROUP by 1,2

ORDER by 2