with raw as (select *, ROW_NUMBER() OVER (ORDER BY event_amount desc) as rank
from terra.staking
where action = 'delegate' and block_timestamp >= CURRENT_DATE - 7 and tx_status = 'SUCCEEDED')
select delegator_address, event_amount
from raw
where rank < 11
order by 2 desc