SELECT
count (DISTINCT TX_HASH) as TXN_Users,
sum (AMOUNT_IN_USD) as USD_Users,
sum (CASE when ORIGIN_FROM_ADDRESS = '{{User_wallet}}' then AMOUNT_IN_USD end) as USD_Target,
count (DISTINCT (CASE when ORIGIN_FROM_ADDRESS = '{{User_wallet}}' then TX_HASH end)) as TXN_Target
FROM avalanche.core.ez_dex_swaps