delegator_address as address, sum(event_amount)

from terra.staking

where action = 'delegate' and currency = 'LUNA'

group by 1

order by 2 DESC

limit 5),

addresses as

address

from topdel),

val as

(select

validator_address_label as validator,

delegator_address as address,

sum(event_amount) as LUNA_staked

from terra.staking

where action = 'delegate' and currency = 'LUNA'

group by 1,2)

select A.address, B.validator, sum(B.LUNA_staked) as LUNA_Delegated

from addresses A

join val B on A.address = B.address

group by 1,2