SELECT

tx_from AS staker,

COUNT(tx_id) AS transaction_count

FROM solana.core.fact_transfers

WHERE tx_to = 'Hdy8hy5eTBriXH1unEiFYWqV48RUhuFVYK79K1Ys5oWs'

AND mint = 'SonicxvLud67EceaEzCLRnMTBqzYUUYNr93DBkBdDES'

GROUP BY staker

),

transaction_distribution AS (

SELECT

CASE

WHEN transaction_count = 1 THEN '1 Transaction'

WHEN transaction_count = 2 THEN '2 Transactions'

WHEN transaction_count = 3 THEN '3 Transactions'

WHEN transaction_count BETWEEN 4 AND 5 THEN '4-5 Transactions'

WHEN transaction_count BETWEEN 6 AND 10 THEN '6-10 Transactions'

ELSE '>10 Transactions'

END AS transaction_bucket,

COUNT(*) AS staker_count

FROM staker_transaction_count

GROUP BY transaction_bucket

SELECT *

FROM transaction_distribution

ORDER BY transaction_bucket;