WITH Kaia_stats AS (
SELECT
b.PROJECT_NAME,
count(DISTINCT a.tx_hash) AS txns,
count(DISTINCT a.ORIGIN_FROM_ADDRESS) AS Users
FROM
kaia.core.fact_event_logs a
JOIN kaia.core.dim_labels b ON a.contract_address = b.address
WHERE
a.TX_SUCCEEDED = 'TRUE'
AND b.label_type IS NOT NULL
AND a.block_timestamp >= '2024-01-01'
GROUP BY 1
)
SELECT
project_name,
txns
FROM
kaia_stats
ORDER BY 2 DESC
LIMIT 10