select

count( distinct a.origin_from_address ) as "traders"

, count( distinct a.tx_hash ) as "swap counts"

, sum( a.amount_in_usd ) as "USD volume"

, case

when a.platform like '%pharaoh%' then 'Pharaoh'

when a.platform like '%uniswap%' then 'Uniswap'

when a.platform like '%trader%' then 'Trader Joe'

when a.platform like '%pangolin%' then 'Pangolin'

when a.platform like '%woofi%' then 'Woofi'

when a.platform like '%balancer%' then 'Balancer'

end

as "platforms"

, case

when a.platform like '%pharaoh%' then '<img src="https://pbs.twimg.com/profile_images/1736075424701239296/vQNQjGPR_400x400.jpg" style="width: 30px; border-radius: 100%;">Pharaoh'

when a.platform like '%uniswap%' then '<img src="https://pbs.twimg.com/profile_images/1696986796478091264/79NZgGom_400x400.jpg" style="width: 30px; border-radius: 100%;">Uniswap'

when a.platform like '%trader%' then '<img src="https://pbs.twimg.com/profile_images/1815754501455855616/6T0PlyLm_400x400.png" style="width: 30px; border-radius: 100%;">Trader Joe'

when a.platform like '%pangolin%' then '<img src="https://pbs.twimg.com/profile_images/1607809611834298369/f-MClvFk_400x400.png" style="width: 30px; border-radius: 100%;">Pangolin'

when a.platform like '%woofi%' then '<img src="https://pbs.twimg.com/profile_images/1813531665227984898/G0X__vPi_400x400.jpg" style="width: 30px; border-radius: 100%;">Woofi'

when a.platform like '%balancer%' then '<img src="https://pbs.twimg.com/profile_images/1656222978919784449/eQgwPTaY_400x400.png" style="width: 30px; border-radius: 100%;">Balancer'

end

as "platforms [img]"