SELECT optimism.core.dim_labels.project_name, count(DISTINCT origin_from_address) AS count_users,
count(distinct tx_hash) AS count_transactions
FROM optimism.core.fact_event_logs
join optimism.core.dim_labels
on optimism.core.fact_event_logs.origin_to_address = optimism.core.dim_labels.address
where block_timestamp >= '{{Start_Date}}'and block_timestamp <= CURRENT_DATE - 1
GROUP BY 1
ORDER BY 2 desc
LIMIT 10