Queries :: Find Static Deviation With Query

ID machine value
1 111 0
2 112 1
3 113 2
4 111 0
5 112 2
6 113 2
7 111 1
8 112 0
9 113 -1
10 111 2
11 112 1
12 113 -1
13 111 1
14 112 -1
15 113 1
16 111 1
17 112 1
18 113 0

I have three machines. They all have random variations, but a machine could also have a static deviation. If the last 4 values are above 0, the deviation is considered static and should be corrected. In this example 111 has a static deviation

Nowadays the operators look at the graphs and when they observe the static deviation they will adjust it.

Question is: Is it possible to use a query to extract 111? In that case I can give operator a warning in stead of him looking at the graph.