dl.label AS contract_name,

SUM(ds.amount_received) AS total_usd_received

FROM

ez_dex_swaps ds

JOIN

ethereum.core.dim_labels dl ON ds.contract_id = dl.contract_id

GROUP BY

ds.contract_id, dl.label

ORDER BY

total_usd_received DESC

LIMIT 10;