SELECT
SENDER AS "Sender Address",
COUNT(*) AS "Transaction Count",
SUM(AMOUNT_IN_USD) AS "Total Sent USD",
TX_TO AS "Receiver Address",
COUNT(DISTINCT TX_TO) AS "Unique Receivers"
FROM
bsc.defi.ez_dex_swaps
WHERE
PLATFORM LIKE '%pancakeswap%'
GROUP BY
1,4
ORDER BY
"Transaction Count" DESC,
"Total Sent USD" DESC
LIMIT 10;