SELECT

COUNT(DISTINCT account_address) AS total_holders,

COUNT(DISTINCT CASE WHEN balance > 500 THEN account_address END) AS holders_over_500,

COUNT(DISTINCT CASE WHEN balance > 1000 THEN account_address END) AS holders_over_1k,

COUNT(DISTINCT CASE WHEN balance > 10000 THEN account_address END) AS holders_over_10k

FROM (

SELECT account_address, balance

FROM solana.core.fact_token_balances

WHERE mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

AND balance > 0

AND block_timestamp = (

SELECT MAX(block_timestamp)

FROM solana.core.fact_token_balances AS inner_table

WHERE inner_table.account_address = solana.core.fact_token_balances.account_address

AND inner_table.mint = '6p6xgHyF7AeE6TZkSmFsko444wqoP15icUSqi2jfGiPN'

)

) AS current_holders;