SELECT
origin_from_address as address,
count(distinct(contract_address)) as n_projects_voted,
count(distinct(tx_hash)) as n_votes
from optimism.core.fact_event_logs
where block_timestamp > current_date - 90
and lower(event_name) like any ('%vote%','%voting%')
group by 1;