Multiple rows with same value in one column, Sql Server

Language: Layout:

IF OBJECT_ID('dbo.ApplicationLog ', 'U') IS NOT NULL 
BEGIN
   DROP TABLE dbo.ApplicationLog
END

CREATE TABLE ApplicationLog
    ([App_name] varchar(13), [date] datetime, [status] varchar(9))
;
    
INSERT INTO ApplicationLog
    ([App_name], [date], [status])
VALUES
    ('Application 1', '2017-03-10 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-11 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-12 00:00:00', 'FAILED'),
    ('Application 1', '2017-03-13 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-14 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-15 00:00:00', 'FAILED'),
    ('Application 1', '2017-03-16 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-17 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-18 00:00:00', 'FAILED'),
    ('Application 1', '2017-03-19 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-20 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-21 00:00:00', 'FAILED'),
    ('Application 1', '2017-03-22 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-23 00:00:00', 'SUCCEEDED'),
    ('Application 1', '2017-03-25 00:00:00', 'SUCCEEDED'),
    ('Application 3', '2017-03-20 00:00:00', 'FAILED'),
    ('Application 3', '2017-03-21 00:00:00', 'FAILED'),
    ('Application 3', '2017-03-22 00:00:00', 'FAILED'),
    ('Application 3', '2017-03-23 00:00:00', 'FAILED'),
    ('Application 3', '2017-03-24 00:00:00', 'FAILED')
;

SELECT [App_name]
FROM (
   SELECT [App_name], [date], [status],
          ROW_NUMBER() OVER (PARTITION BY App_name ORDER BY [date]) 
          -
          ROW_NUMBER() OVER (PARTITION BY App_name, 
                                          CASE 
                                             WHEN status = 'FAILED' THEN 1
                                             ELSE 2 
                                          END 
                             ORDER BY [date]) AS grp
   FROM ApplicationLog) AS t
WHERE status = 'FAILED'   
GROUP BY [App_name], grp
HAVING COUNT(*) >= 5

DROP TABLE dbo.ApplicationLog

View schema
Execution time: 0,03 sec, rows selected: 1, rows affected: 20, absolute service time: 0,17 sec