WITH bridge AS (
SELECT *
FROM avalanche.core.dim_labels
WHERE label_type = 'layer2'
),
txs AS (
SELECT *
FROM avalanche.core.fact_event_logs
WHERE tx_status = 'SUCCESS'
)
SELECT
b.project_name AS "Project",
COUNT(DISTINCT t.origin_from_address) AS "Users"
FROM bridge b
JOIN txs t ON b.address = t.contract_address
GROUP BY 1
ORDER BY 2 DESC