with sender as
(select
sum(AMOUNT) as send, SENDER
from terra.core.ez_transfers
where
CURRENCY='uluna'
group by 2),
RECEIVER
as
(
select
sum(AMOUNT) as receive, RECEIVER
from terra.core.ez_transfers
where
CURRENCY='uluna'
group by 2
)
, asa as
(select
case when receive is null then 0 else receive end as receivee, RECEIVER as user , (receivee-send)/1e6 as balance
from sender a left join RECEIVER b
on a.sender=b.RECEIVER
order by balance desc)
(select
count(*) as wallet_number,
'0-1' as balance_range
from asa
where balance < 1 )
union ALL