platform,

SUM(

CASE

WHEN amount_in_usd IS NOT NULL

AND amount_out_usd IS NOT NULL THEN 1

ELSE 0

END

) / COUNT(*) :: FLOAT AS success_rate

kaia.defi.ez_dex_swaps

GROUP BY

platform

ORDER BY

success_rate DESC;