Q1 As

(select * from polygon.core.fact_event_logs S),

Q2 As

(select * from polygon.core.dim_labels D)

select

case WHEN project_name LIKE '%sushiswap%' THEN 'SushiSwap'

WHEN project_name LIKE '%uniswap%' THEN 'UniSwap' end as dex,

count(DISTINCT tx_hash) as swaps,

count(DISTINCT origin_from_address) as users

from Q1 Left Join Q2

ON contract_address = address

where not address is NULL

AND( project_name LIKE '%sushiswap%'

OR project_name LIKE '%uniswap%' )

GROUP BY Dex