SELECT

VALIDATOR_ADDRESS,

DELEGATOR_ADDRESS,

SUM(AMOUNT) as total_amount

FROM

sei.gov.fact_staking

WHERE

ACTION = 'delegate'

AND TX_SUCCEEDED = TRUE

GROUP BY

VALIDATOR_ADDRESS, DELEGATOR_ADDRESS

),

validator_totals AS (

SELECT

VALIDATOR_ADDRESS,

SUM(total_amount) as total_delegated

FROM

validator_delegations

GROUP BY

VALIDATOR_ADDRESS

vt.VALIDATOR_ADDRESS,

vt.total_delegated,

vd.DELEGATOR_ADDRESS,

vd.total_amount as delegator_amount,

(vd.total_amount / vt.total_delegated) * 100 as percentage_of_total

FROM

validator_totals vt

JOIN

validator_delegations vd ON vt.VALIDATOR_ADDRESS = vd.VALIDATOR_ADDRESS

ORDER BY

vt.total_delegated DESC,

vd.total_amount DESC