ADDRESS_NAME,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT ORIGIN_FROM_ADDRESS) as swappers

FROM bsc.core.fact_event_logs

LEFT outer JOIN flipside_prod_db.crosschain.address_labels

ON contract_address = address

WHERE tx_hash IN (

SELECT DISTINCT tx_hash

FROM bsc.core.fact_event_logs

WHERE event_name LIKE 'Swap'

AND event_name LIKE 'Transfer'

AND not address_name is NULL

GROUP by 1

ORDER BY 3 DESC

LIMIT 10