WITH t1 AS (
SELECT DISTINCT origin_from_address as claimers
FROM optimism.core.fact_event_logs
WHERE origin_to_address = LOWER('0xFeDFAF1A10335448b7FA0268F56D2B44DBD357de')
AND event_name = 'Claimed' )
SELECT Date_trunc('day',BLOCK_TIMESTAMP) AS Date, COUNT(*)
FROM optimism.core.fact_event_logs
WHERE event_name = 'DelegateVotesChanged'
AND origin_to_address = '0x4200000000000000000000000000000000000042'
AND origin_from_address IN (SELECT claimers FROM t1)
GROUP BY 1