base as (

select

case

when amount = 0 then 'Mad List'

when amount = 6.9 then 'Mad Rug'

else 'AAAAA'

end as mint_type,

count(distinct tx_id) as mints

-- mint

-- *

FROM

-- solana.core.fact_transactions

solana.core.fact_transfers

-- solana.core.fact_events

where

tx_to =

-- array_contains(

'2RtGg6fsFiiF1EQzHqbd66AhW7R5bWeQGpTbv2UMkCdW'::variant

-- , signers

-- and mint = 'So11111111111111111111111111111111111111112'

and block_timestamp >= '2023-02-28'

and amount != 0.1

group by

mint_type

)

*

base

order by MINT_TYPE desc