SELECT SUM(amount) / POWER(10, 6) AS total_staked_in_sei

FROM sei.gov.fact_staking

WHERE action IN ('delegate', 'redelegate') -- Include redelegation

),

validator_stakes AS (

SELECT

validator_address,

(SUM(amount) / POWER(10, 6)) AS staked_to_validator

FROM

sei.gov.fact_staking

WHERE

action IN ('delegate', 'redelegate') -- Include redelegation

GROUP BY

validator_address

SELECT

CASE

WHEN v.validator_address = 'seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh' THEN 'Flipside'

WHEN v.validator_address = 'seivaloper1wuj3xg3yrw4ryxn9vygwuz0necs4klj7j9nay6' THEN 'Hype Infra'

WHEN v.validator_address = 'seivaloper1ummny4p645xraxc4m7nphf7vxawfzt3p5hn47t' THEN 'Everstake'

WHEN v.validator_address = 'seivaloper146m089lq8mkqw6w0mmlhxz6247g2taha89at74' THEN 'Rhino'

WHEN v.validator_address = 'seivaloper1xm0pjt3qsdlc6u4n7fjpycqd5h7zwla7tz8m37' THEN 'Anchorage Digital'

WHEN v.validator_address = 'seivaloper16pj5gljqnqs0ajxakccfjhu05yczp98743ctgy' THEN 'Chorus One'

WHEN v.validator_address = 'seivaloper1d3ar2psa9ca55q45jg3q6f3ltmpr0ndqqlty87' THEN 'Sei 1'

WHEN v.validator_address = 'seivaloper1xhxnad3c86q3d8ggsyu24j7r0y5k3ef4uhh9e2' THEN 'Sei 0'

WHEN v.validator_address = 'seivaloper1vjj609rued3hxztj6gauca3w7fzu96g4yp6y39' THEN 'Open Zeppelin'

WHEN v.validator_address = 'seivaloper1w6jrkym8v0nc63kud6erdlt06c2eawhr85hec0' THEN 'Vertex by SEC 3'

WHEN v.validator_address = 'seivaloper10c6rrz55ukkaf7rjeerhpxwpqel4tllzs8vgfq' THEN 'Zellic'

WHEN v.validator_address = 'seivaloper1s2qd4usk9sfavnlzkyvkq7e7tsds7z8ldvkhca' THEN 'PeckShield'

WHEN v.validator_address = 'seivaloper1wwfpmcvehq6yqdxfccs5rdr745q3kmy06l9d0d' THEN 'King Nodes'

WHEN v.validator_address = 'seivaloper1y82m5y3wevjneamzg0pmx87dzanyxzht0kepvn' THEN 'Figment'

WHEN v.validator_address = 'seivaloper1mpe9rdk7ycujge7r9ncjt4ekamgrdcygvzwqe8' THEN 'Polkachu.com'

WHEN v.validator_address = 'seivaloper1mm5p6ak2w94cwry0n42px3ssajgytxnwfvd4w8' THEN 'Crosnet'

WHEN v.validator_address = 'seivaloper10plkkmv757pfydyqc97s87zgqt84vry6dx6q9k' THEN 'Staked'

WHEN v.validator_address = 'seivaloper18tpdet22kpvswxayekwn55ry0r5acx4kaauupk' THEN 'A41'