Count(DISTINCT tx_hash) AS total_txs

FROM (SELECT *

FROM bsc.core.dim_labels

INNER JOIN bsc.core.fact_event_logs

ON contract_address = address)

WHERE label_type = 'dex'

GROUP BY 1

ORDER BY 2 DESC

LIMIT 10