SELECT

address,

CASE address

WHEN '2ScMYaQVu8UdmUZ7ErFdA8T2A1o1hYjmUfHrzmzCJsjF' THEN 'Jump'

WHEN '4hwY641XT3oaAwh3ZpDC5VtBie3ZC76yAUBABUjfPsoq' THEN 'Publisher + MMs'

WHEN 'mStMrv5XPqqFG6HnbNNrdJw67wV4s3Ru8BUFDQTArXN' THEN 'Airdrop/Project/MMs(eg.Winter)'

WHEN '5cz3Jz3QnDmTsQiw5MwkfV9tq4zf2yCzWcH7tXq5BxCw' THEN 'project team'

WHEN '5WumPYv4jDPRqWjWr3EeybLczpcohHrMPShK9WQ85qfY' THEN 'project team'

WHEN 'Ep6aZ3eNtiBpLSNeweGDMbjRPRtjGkFPugnHp81U79Jb' THEN 'project team'

WHEN 'Cr1g9mY1EFHWSbq7X8LNjzQCWRxmZUimUA5iEswdpgkj' THEN 'Wintermute + MMs'

WHEN 'HTyLUKeseSzwb5wk1qXPMZUgi857BUfgH36KRL98EUzn' THEN 'project team'

WHEN 'Cp4UF63krdQraHzvEX4tYssD1KQHsykxiMvZQiudW67Z' THEN 'project team'

ELSE 'Unknown'

END as name

FROM (VALUES

('2ScMYaQVu8UdmUZ7ErFdA8T2A1o1hYjmUfHrzmzCJsjF'),

('4hwY641XT3oaAwh3ZpDC5VtBie3ZC76yAUBABUjfPsoq'),

('mStMrv5XPqqFG6HnbNNrdJw67wV4s3Ru8BUFDQTArXN'),

('5cz3Jz3QnDmTsQiw5MwkfV9tq4zf2yCzWcH7tXq5BxCw'),

('5WumPYv4jDPRqWjWr3EeybLczpcohHrMPShK9WQ85qfY'),

('Ep6aZ3eNtiBpLSNeweGDMbjRPRtjGkFPugnHp81U79Jb'),

('Cr1g9mY1EFHWSbq7X8LNjzQCWRxmZUimUA5iEswdpgkj'),

('HTyLUKeseSzwb5wk1qXPMZUgi857BUfgH36KRL98EUzn'),

('Cp4UF63krdQraHzvEX4tYssD1KQHsykxiMvZQiudW67Z')

) AS T (address)

, cex_addresses AS (

SELECT address FROM solana.core.dim_labels WHERE label_type = 'cex'

UNION

SELECT 'A77HErqtfN1hLLpvZ9pCtu66FEtM8BveoaKbbMoZ4RiR' --Bitget

UNION

SELECT '43DbAvKxhXh1oSxkJSqGosNw3HpBnmsWiak6tB5wpecN' --Backpack

UNION

SELECT 'BbHG9GvPActFGogv3iNrpDAj4qpXr8t3jF16uGxXcKci' --Backpack