SELECT

labels.project_name AS name,

COUNT(DISTINCT(logs.tx_hash)) as number_of_transactions

FROM

arbitrum.core.fact_event_logs logs

JOIN

arbitrum.core.dim_labels labels

ON

logs.contract_address = labels.address

WHERE

label_type IS NOT NULL

GROUP BY name

ORDER BY number_of_transactions DESC

LIMIT 10