SELECT

OWNER,

CASE

WHEN mint = 'AZZyEKLE288XgF795nkktMC9poBgsq93mkcZQxRrpump' THEN 'XRP on Solana'

WHEN mint = '6xc8faPe6n3ZacgT5a3ygQGgDUpfnimaDcqL3c4Ppump' THEN 'Pikaclaus'

WHEN mint = '7JRAtm3hGnF4iEeRJdcxBtB5zovzkcd2tgpw6Ns1pump' THEN 'The Gingerbread Man'

WHEN mint = 'CSh9t2fx2TAE25AiZ9oagdcuHomTQoCE1PGxaMjfpump' THEN 'SNOOPY'

ELSE 'Other'

END AS Name,

BALANCE,

ROW_NUMBER() OVER(PARTITION BY OWNER ORDER BY block_timestamp DESC) AS rank

FROM

solana.core.fact_token_balances

WHERE

SUCCEEDED

AND mint IN ('AZZyEKLE288XgF795nkktMC9poBgsq93mkcZQxRrpump',

'6xc8faPe6n3ZacgT5a3ygQGgDUpfnimaDcqL3c4Ppump',

'7JRAtm3hGnF4iEeRJdcxBtB5zovzkcd2tgpw6Ns1pump',

'CSh9t2fx2TAE25AiZ9oagdcuHomTQoCE1PGxaMjfpump')

AND block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '1 day'

SELECT

Name,

COUNT(DISTINCT OWNER) AS "No of Holders"

FROM

address_balance

WHERE

BALANCE > 0

AND rank = 1

AND Name ='{{ Name}}'

GROUP BY

Name;