CASE when balance < 100 then 'a Below 100 AREO'

when balance < 1000 then 'b 100 - 1K AREO'

when balance < 10000 then 'c 1K - 10K AREO'

when balance < 100000 then 'd 10K - 100K AREO'

when balance < 1000000 then 'e 100K - 1M AREO'

when balance < 10000000 then 'f 1M - 10M AREO'

when balance < 100000000 then 'g 10M - 100M AREO'

else 'h 100M+ AREO'end as holder_group,

count(*) as holders,

sum(balance) as token_supply

FROM (

SELECT

user as wallet,

sum(CASE when tx_type LIKE 'in' then amt else -1 * amt end) as balance

FROM (

SELECT

FROM_address as user,

'out' as tx_type,

sum(raw_amount / power(10, 18)) as amt

FROM base.core.fact_token_transfers

WHERE contract_address LIKE lower('0x940181a94A35A4569E4529A3CDfB74e38FD98631')

GROUP BY 1,2

UNION

SELECT

to_address as user,

'in' as tx_type,

sum(raw_amount / power(10, 18)) as amt

FROM base.core.fact_token_transfers

WHERE contract_address LIKE lower('0x940181a94A35A4569E4529A3CDfB74e38FD98631')