SELECT

validator_address AS "Validator",

SUM(

CASE

WHEN action = 'delegate' THEN amount / 1000000

ELSE 0

END

) AS "Total Staked SEI"

FROM

sei.gov.fact_staking

WHERE

tx_succeeded = TRUE

AND block_timestamp >= DATEADD(month, -3, CURRENT_DATE)

AND block_timestamp < CURRENT_DATE

AND action = 'delegate'

GROUP BY

validator_address

HAVING

"Total Staked SEI" > 0

CASE

WHEN s."Validator" = 'seivaloper16znh8ktn33dwnxxc9q0jmxmjf6hsz4tl0s6vxh' THEN 'Flipside'

WHEN s."Validator" = 'seivaloper1wuj3xg3yrw4ryxn9vygwuz0necs4klj7j9nay6' THEN 'Hype Infra'

WHEN s."Validator" = 'seivaloper1ummny4p645xraxc4m7nphf7vxawfzt3p5hn47t' THEN 'Everstake'

WHEN s."Validator" = 'seivaloper146m089lq8mkqw6w0mmlhxz6247g2taha89at74' THEN 'Rhino'

WHEN s."Validator" = 'seivaloper1xm0pjt3qsdlc6u4n7fjpycqd5h7zwla7tz8m37' THEN 'Anchorage Digital'

WHEN s."Validator" = 'seivaloper16pj5gljqnqs0ajxakccfjhu05yczp98743ctgy' THEN 'Chorus One'

WHEN s."Validator" = 'seivaloper1d3ar2psa9ca55q45jg3q6f3ltmpr0ndqqlty87' THEN 'Sei 1'

WHEN s."Validator" = 'seivaloper1xhxnad3c86q3d8ggsyu24j7r0y5k3ef4uhh9e2' THEN 'Sei 0'

WHEN s."Validator" = 'seivaloper1vjj609rued3hxztj6gauca3w7fzu96g4yp6y39' THEN 'Open Zeppelin'

WHEN s."Validator" = 'seivaloper1w6jrkym8v0nc63kud6erdlt06c2eawhr85hec0' THEN 'Vertex by Sec 3'

WHEN s."Validator" = 'seivaloper10c6rrz55ukkaf7rjeerhpxwpqel4tllzs8vgfq' THEN 'Zellic'

WHEN s."Validator" = 'seivaloper1s2qd4usk9sfavnlzkyvkq7e7tsds7z8ldvkhca' THEN 'PeckShield'

WHEN s."Validator" = 'seivaloper1wwfpmcvehq6yqdxfccs5rdr745q3kmy06l9d0d' THEN 'King Nodes'