SELECT project_name,
Count(DISTINCT tx_hash) AS total_txs_count,
Count(DISTINCT origin_from_address) AS no_of_users
FROM (SELECT *
FROM bsc.core.dim_labels
INNER JOIN bsc.core.fact_event_logs
ON contract_address = address)
WHERE label_type = 'dex'
and tx_status = 'SUCCESS'
GROUP BY 1
ORDER BY 2 DESC