SELECT

day as day1,

min(teat1) as min_teat

from (

SELECT

*,

sum(VOTING_RATIO) OVER (PARTITION BY day order BY VOTING_RATIO desc) as teat1,

COUNT(*) OVER (PARTITION BY day order BY VOTING_RATIO desc) as teat2

FROM (

SELECT

*,

(sum(token_flow_total) OVER (PARTITION BY validator_address ORDER BY DAY)) / (sum(token_flow_total) OVER (ORDER BY DAY)) as voting_ratio

FROM (

SELECT

DAY,

validator_address,

SUM(token_flow) AS TOKEN_FLOW_TOTAL

FROM (

SELECT *

FROM (

SELECT

date_trunc('week', block_timestamp) as day,

validator_address,

sum(CASE WHEN action LIKE 'undelegate' THEN (amount / power(10,6)) * -1

else (amount / power(10,6)) end) as token_flow

FROM osmosis.core.fact_staking

--WHERE action LIKE 'undelegate'

where currency LIKE 'uosmo'

AND REDELEGATE_SOURCE_VALIDATOR_ADDRESS is NULL

GROUP BY 1,2

)

UNION