SELECT TX_TO AS Receiver, SUM(AMOUNT) AS Token

FROM solana.core.fact_transfers

WHERE MINT = '73xsLcBnLnc9bh81cqVKqj8uEyiarXng5ZwJuTbnVebG'

GROUP BY 1

UNION ALL

SELECT TX_FROM AS Receiver, SUM(-AMOUNT) AS Token

FROM solana.core.fact_transfers

WHERE MINT = '73xsLcBnLnc9bh81cqVKqj8uEyiarXng5ZwJuTbnVebG'

GROUP BY 1

),

MAIN_BALANCE AS (

SELECT Receiver, SUM(Token) AS "Holder's Balance"

FROM BALANCE

GROUP BY 1

SELECT

CASE

WHEN "Holder's Balance" < 3055959812.03659 THEN 'Less than average'

WHEN "Holder's Balance" >= 3055959812.03659 AND "Holder's Balance" < 2 * 3055959812.03659 THEN '1x - 2x average'

WHEN "Holder's Balance" >= 2 * 3055959812.03659 AND "Holder's Balance" < 5 * 3055959812.03659 THEN '2x - 5x average'

WHEN "Holder's Balance" >= 5 * 3055959812.03659 AND "Holder's Balance" < 10 * 3055959812.03659 THEN '5x - 10x average'

WHEN "Holder's Balance" >= 10 * 3055959812.03659 AND "Holder's Balance" < 5000059903021.75 THEN '10x average - Half Max'

ELSE 'Half Max - Max'

END AS Balance_Range,

COUNT(*) AS Wallet_Count

FROM MAIN_BALANCE

WHERE "Holder's Balance" > 0.01

GROUP BY 1

ORDER BY 1;