SELECT distinct swapper as users,

swap_program

from algorand.swaps

where (swap_program = 'pactfi' or swap_program = 'algofi' or swap_program = 'wagmiswap')

SELECT

count ( n.users ) as users,

CASE WHEN o.swap_program='tinyman' then 'yes' ELSE 'no' end as newusers_and_tinyman

from newusers n left join algorand.swaps o on n.users= o.swapper

group by newusers_and_tinyman