CONCAT(SYMBOL_IN, '->', SYMBOL_OUT) AS "Trading Pairs",

COUNT(*) AS "Transaction Count",

SUM((AMOUNT_IN_USD+ AMOUNT_OUT_USD)/2) AS "Transaction Volume"

bsc.defi.ez_dex_swaps

WHERE 1=1

AND PLATFORM like '%pancakeswap%'

AND BLOCK_TIMESTAMP >= '2024-01-01'

AND "Trading Pairs" IS NOT NULL

GROUP BY

"Trading Pairs"

"Transaction Volume" IS NOT NULL

AND "Transaction Count" IS NOT NULL

ORDER BY

"Transaction Count" DESC,

"Transaction Volume" DESC

LIMIT 10;