1SELECT 2 value, 3 sum(dur) as dur_sum 4FROM ( 5 SELECT value, 6 lead(ts) OVER (PARTITION BY name, ref ORDER BY ts) - ts AS dur 7 FROM counters 8) 9WHERE value > 0 10GROUP BY value 11ORDER BY dur_sum desc 12