from flipside_prod_db.solana.fact_transfers

where mint in ('WATErpZ2ZBjgAxyttoEjckuTuCe9pEckSabCeENLTYq' , 'FireKR7LgjyzjsLnxaNZwa7dnJncDSidD4cXGhTGz2eU' ,'woodN5KSiHEAhaCrZVh3vScGta7u6r5Vp3UbqDFuD4e' , 'EaRtHRxHp1ftdfnJFds9UrCDNaSGxhdnRUucevNr1DzA' , 'Meta1cQ29N8S4cSwJScHZYtXV6J5Cy55oEA8vRVhh8K'))

select day, count(distinct(tx_id)) as buy , case when mint = 'WATErpZ2ZBjgAxyttoEjckuTuCe9pEckSabCeENLTYq' then 'Water Crystal'

when mint = 'FireKR7LgjyzjsLnxaNZwa7dnJncDSidD4cXGhTGz2eU' then 'Fire Crystal' when mint = 'woodN5KSiHEAhaCrZVh3vScGta7u6r5Vp3UbqDFuD4e' then 'Wood Crystal'

when mint = 'EaRtHRxHp1ftdfnJFds9UrCDNaSGxhdnRUucevNr1DzA' then 'Earth Crystal' when mint = 'Meta1cQ29N8S4cSwJScHZYtXV6J5Cy55oEA8vRVhh8K' then 'Metal Crystal'

end as nft_types from crystal group by 1,3

order by 1