SELECT contract_address,
address_name,
label_type,
label_subtype,
project_name,
count(DISTINCT tx_hash) as n_txns
FROM optimism.core.fact_event_logs a
LEFT JOIN optimism.core.dim_labels b
ON a.contract_address = b.address
WHERE date_trunc('day',block_timestamp) = current_date-1
GROUP BY contract_address,address_name, label_type,label_subtype,project_name
ORDER BY n_txns DESC
LIMIT 10