Stackoverflow - Find the last stop time in a series of action sql, Sql Server

Language: Layout:

--Sql Server 2014 Express Edition
--Batches are separated by 'go'

WITH yourTable AS (
    SELECT 3 AS id, 1 AS video_click_id, '2016-05-19 13:59:07.437' AS action_timestamp, 'play' AS action UNION ALL
    SELECT 4,  1, '2016-05-19 13:59:13.413', 'stop' UNION ALL
    SELECT 6,  1, '2016-05-19 15:59:40.213', 'stop' UNION ALL
    SELECT 8,  2, '2016-05-19 16:29:11.950', 'play' UNION ALL
    SELECT 9,  2, '2016-05-19 16:29:27.090', 'stop' UNION ALL
    SELECT 10, 2, '2016-05-19 16:29:29.390', 'play' UNION ALL
    SELECT 12, 2, '2016-05-19 16:29:29.390', 'stop' UNION ALL
    SELECT 13, 3, '2016-05-19 20:59:07.437', 'play' UNION ALL
    SELECT 14, 3, '2016-05-19 20:59:13.413', 'stop' UNION ALL
    SELECT 15, 3, '2016-05-19 20:59:40.213', 'stop' UNION ALL
    SELECT 26, 3, '2016-05-19 20:59:40.213', 'stop'
    )

SELECT
    t.id,
    t.video_click_id,
    t.action_timestamp,
    t.action
FROM
(
    SELECT *,
        ROW_NUMBER() OVER (PARTITION BY video_click_id ORDER BY action_timestamp) rn
    FROM yourTable t0
    WHERE action = 'stop'
    AND NOT EXISTS
    (
        SELECT 1
        FROM yourTable t1
        WHERE t1.video_click_id = t0.video_click_id 
        AND t1.action = 'play'
        AND t1.action_timestamp > t0.action_timestamp
    )
) t
WHERE t.rn = 1;

View schema
Execution time: 0 sec, rows selected: 3, rows affected: 0, absolute service time: 0,16 sec