SELECT
COUNT(*) AS "Number of Swaps"
,COUNT(DISTINCT origin_from_address) AS "Number of Swappers"
,SUM((AMOUNT_IN_USD + AMOUNT_OUT_USD)/2) AS "Total Volume Traded"
FROM
bsc.defi.ez_dex_swaps
WHERE 1=1
AND PLATFORM LIKE '%pancakeswap%'
AND EVENT_NAME = 'Swap'