baseswap_users as (

SELECT origin_from_address as user

FROM base.defi.ez_dex_swaps

WHERE platform = 'baseswap'

SELECT DISTINCT platform,

COUNT(DISTINCT origin_from_address) as baseswap_users,

baseswap_users/(SELECT COUNT(DISTINCT user) FROM baseswap_users)*100 as percent_of_all

FROM base.defi.ez_dex_swaps d

JOIN baseswap_users b ON d.origin_from_address = b.user

WHERE platform <> 'baseswap'

GROUP BY platform