with all_users as (

select

CASE WHEN mint = 'HaP8r3ksG76PhQLTqR8FYBeNiQpejcFbQmiHbg787Ut1' THEN 'TRUMP'

WHEN mint = '3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o' THEN 'BODEN'

WHEN mint = 'FTyr4aoR52GY5EWGuxSzEAY6szaYKzi3WAmHmeYppump' THEN 'HARRIS'

WHEN mint = 'Gp5PYbvVkF5LqqwwPP1UazFExvnnUekjqZG7x9vkpump' THEN 'TADDY'

WHEN mint = 'HnKkzR1YtFbUUxM6g3iVRS2RY68KHhGV7bNdfF1GCsJB' THEN 'KAMA'

WHEN mint = 'FU1q8vJpZNUrmqsciSjp8bAKKidGsLmouB8CBdf8TKQv' THEN 'TREMP'

-- WHEN mint = '9EYScpiysGnEimnQPzazr7Jn9GVfxFYzgTEj85hV9L6U' THEN 'TOOKER'

WHEN mint = 'KMnDBXcPXoz6oMJW5XG4tXdwSWpmWEP2RQM1Uujpump' THEN 'FIGHT'

WHEN mint = '7D7BRcBYepfi77vxySapmeqRNN1wsBBxnFPJGbH5pump' THEN 'DMAGA'

WHEN mint = 'Gk2kRrwNMBU4Dn9JhC1Dks8G5X9nqi4ZE5jMvK6bdgEd' THEN 'PTRUMP'

WHEN mint = '8Sk1mazEDN1L6P6E9di4Xgza3icJw4Za9KUKqnUNEQrM' THEN 'MAWA'

end as memecoin,

date_trunc('d',block_timestamp) as date,

count(DISTINCT tx_from) as user

FROM solana.core.fact_transfers

WHERE mint in (

'HaP8r3ksG76PhQLTqR8FYBeNiQpejcFbQmiHbg787Ut1', -- MAGA / $TRUMP

'3psH1Mj1f7yUfaD5gh6Zj7epE8hhrMkMETgv5TshQA4o', -- Jeo Boden / $BODEN

'FTyr4aoR52GY5EWGuxSzEAY6szaYKzi3WAmHmeYppump', -- Kamala Harris / $HARRIS

'Gp5PYbvVkF5LqqwwPP1UazFExvnnUekjqZG7x9vkpump', -- Daddy Trump / $TADDY

'HnKkzR1YtFbUUxM6g3iVRS2RY68KHhGV7bNdfF1GCsJB', -- Kamala Horris / $KAMA

'FU1q8vJpZNUrmqsciSjp8bAKKidGsLmouB8CBdf8TKQv', -- Doland Tremp / $TREMP

'KMnDBXcPXoz6oMJW5XG4tXdwSWpmWEP2RQM1Uujpump', -- Fight to MAGA / $FIGHT

'7D7BRcBYepfi77vxySapmeqRNN1wsBBxnFPJGbH5pump', -- Dark MAGA / $DMAGA

'Gk2kRrwNMBU4Dn9JhC1Dks8G5X9nqi4ZE5jMvK6bdgEd', -- PEPE / $PTRUMP

'8Sk1mazEDN1L6P6E9di4Xgza3icJw4Za9KUKqnUNEQrM' -- Kumala Harris / $MAWA

AND date_trunc('d',block_timestamp) >= current_date-15

GROUP by 1,2