ab_swap.sql

SELECT
		tests.test_enum || ', ' || (s.time_spent_working::float / (s.duration::float / 1000.0))
from segments s
inner join calls c on c.id = s.call_id
inner join call_tests tests on tests.call_id = c.id
where c.status = 600
 	and (s.time_spent_working::float / (s.duration::float / 1000.0)) < 30.0 -- remove potential outliers
    and tests.test_uid = 'label_swap'
order by tests.test_enum