SELECT
DELEGATOR_ADDRESS,
sum(amount/power(10, 6))
FROM osmosis.core.fact_staking
left outer join osmosis.core.fact_validators
on address = VALIDATOR_ADDRESS
WHERE action LIKE 'delegate'
--and delegator_address IN (SELECT * from tab1)
AND block_timestamp > '2022-10-25'
GROUP BY 1
ORDER BY 2 DESC
LIMIT 100