1SELECT 2 ts, 3 lead(ts, 1, ts) OVER (PARTITION BY name ORDER BY ts) - ts AS dur, 4 value 5FROM counters 6WHERE ref = 1; 7