from terra.gov_submit_proposal

group by 1

order by 2 desc),

holding as (select address, sum(balance) as LUNA_holding

from terra.daily_balances

where currency = 'LUNA' and address in (select proposer from prop) and date = CURRENT_DATE

group by 1)

select a.proposer, a.proposal_submitted, b.LUNA_holding, CASE

when b.LUNA_holding > 10000 then 'WHALE'

else 'RETAIL' end as WHALE_RETAIL

from prop a

join holding b on a.proposer = b.address

order by 2 desc