decoded_log:"domainName" as domain_name,

split(domain_name,'.')[0] as domain,

LENGTH(domain) as len,

to_timestamp(decoded_log:"expiry")::date as expire_date,

datediff('day',a.block_timestamp::date,expire_date) as difference,

CASE

WHEN difference = 365 THEN '1 Year'

WHEN difference = 730 THEN '2 Years'

WHEN difference = 1095 THEN '3 Years'

WHEN difference = 1460 THEN '4 Years'

WHEN difference = 1825 THEN '5 Years'

WHEN difference = 2190 THEN '6 Years'

WHEN difference = 2555 THEN '7 Years'

WHEN difference = 2920 THEN '8 Years'

WHEN difference = 3650 THEN '10 Years'

WHEN difference = 4015 THEN '11 Years'

WHEN difference = 5475 THEN '15 Years'

WHEN difference = 7300 THEN '20 Years'

WHEN difference = 10950 THEN '30 Years'

ELSE difference || ' Days' END AS duration ,

decoded_log:"owner" as owner,

decoded_log:"tokenId" as token_id,

value as mint_amount

from ink.core.ez_decoded_event_logs a join ink.core.fact_transactions b on a.tx_hash = b.tx_hash

where event_name = 'MintedDomain'

and contract_address = lower('0xFb2Cd41a8aeC89EFBb19575C6c48d872cE97A0A5')

and a.TX_SUCCEEDED = 'TRUE')

,

tb2 as ( select owner,

token_id,

duration,

from tb1)

select count(distinct token_id) as domains,