如何用SQL Server 查询下面数据State 为1的时间间隔
4-10行间隔时间,19-23行间隔时间,27-33行间隔时间
NO State DATETIME
1 0 5/31/24 13:30
2 0 5/31/24 13:31
3 0 5/31/24 13:32
4 1 5/31/24 13:33
5 1 5/31/24 13:34
6 1 5/31/24 13:35
7 1 5/31/24 13:36
8 1 5/31/24 13:37
9 1 5/31/24 13:40
10 1 5/31/24 13:41
11 0 5/31/24 13:42
12 0 5/31/24 13:43
13 0 5/31/24 13:44
14 0 5/31/24 13:45
15 0 5/31/24 13:46
16 0 5/31/24 13:47
17 0 5/31/24 13:48
18 0 5/31/24 13:49
19 1 5/31/24 13:50
20 1 5/31/24 13:51
21 1 5/31/24 13:52
22 1 5/31/24 13:53
23 1 5/31/24 13:54
24 0 5/31/24 13:55
25 0 5/31/24 13:56
26 0 5/31/24 13:57
27 1 5/31/24 13:58
28 1 5/31/24 13:59
29 1 5/31/24 14:00
30 1 5/31/24 14:01
31 1 5/31/24 14:02
32 1 5/31/24 14:03
33 1 5/31/24 14:04
34 0 5/31/24 14:05
35 0 5/31/24 14:06
36 0 5/31/24 14:07
37 1 5/31/24 14:08
38 1 5/31/24 14:09