-- SQL credits to Ali3n from Bonk Holders(https://flipsidecrypto.xyz/Ali3N/q/untitled-query-8cTLZA) WITH address AS ( SELECT DISTINCT signers[0] AS users FROM solana.core.fact_nft_sales s JOIN solana.core.dim_labels l ON s.mint = l.address JOIN solana.core.fact_events e ON s.program_id = e.program_id AND s.tx_id = e.tx_id AND s.block_timestamp::date = e.block_timestamp::date WHERE (label LIKE 'claynosaurz%' OR label = 'sardinhas') AND e.succeeded = 'true' GROUP BY 1 ), balances AS ( SELECT block_timestamp::date AS date, tx_from AS User1, sum (amount)*-1 AS Volume FROM solana.core.fact_transfers WHERE mint = 'So11111111111111111111111111111111111111112' GROUP BY 1,2 UNION ALL SELECT block_timestamp::Date AS date, tx_to AS User1, sum (amount) AS Volume FROM solana.core.fact_transfers WHERE mint = 'So11111111111111111111111111111111111111112' GROUP BY 1,2 ), balance_table AS ( SELECT date, User1, sum (Volume) AS balance, sum (balance) over (partition BY User1 ORDER BY date rows BETWEEN unbounded preceding AND current row) AS User_balance FROM balances WHERE User1 IN (SELECT users FROM address) GROUP BY 1,2 ) SELECT CASE WHEN balance < 0.1 THEN 'Plankton<0.1' WHEN balance >= 0.1 AND balance < 1 THEN 'Shrimp<1' WHEN balance >= 1 AND balance < 10 THEN 'Crab<10' WHEN balance >= 10 AND balance < 50 THEN 'Fish<50' WHEN balance >= 50 AND balance < 100 THEN 'Octopuses<100' WHEN balance >= 100 AND balance < 500 THEN 'Dolphins<500' WHEN balance >= 500 AND balance < 1000 THEN 'Sharks<1000' WHEN balance >= 10000 THEN 'Whales>1000' END AS distribution, count (DISTINCT user1) AS Users_Count FROM balance_table WHERE balance > 0 AND date >= '2023-01-01' GROUP BY 1 HAVING distribution IS NOT null ORDER BY 2 DESC -- LIMIT 100 -- source [What is a Dolphine?](https://cryptowallet.com/glossary/dolphin/#:~:text=While%20those%20with%20really%20large,the%20planktons%20and%20the%20whales.)

The People like the Clay Dinos