Step 1: Select rows where 'engine__s' is 'zakspeed s4 t / c'.
year |
chassis |
engine__s |
tyres |
points |
1985 |
zakspeed 841 |
zakspeed s4 t / c |
g |
0 |
1986 |
zakspeed 861 |
zakspeed s4 t / c |
g |
0 |
1987 |
zakspeed 861 zakspeed 871 |
zakspeed s4 t / c |
g |
2 |
1988 |
zakspeed 881 |
zakspeed s4 t / c |
g |
0 |
1989 |
zakspeed 891 |
yamaha v8 |
p |
0 |
Step 2: Select rows where 'year' is between 1985 and 1988.
year |
chassis |
engine__s |
tyres |
points |
1985 |
zakspeed 841 |
zakspeed s4 t / c |
g |
0 |
1986 |
zakspeed 861 |
zakspeed s4 t / c |
g |
0 |
1987 |
zakspeed 861 zakspeed 871 |
zakspeed s4 t / c |
g |
2 |
1988 |
zakspeed 881 |
zakspeed s4 t / c |
g |
0 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 4, otherwise return FALSE.
year |
chassis |
engine__s |
tyres |
points |
1985 |
zakspeed 841 |
zakspeed s4 t / c |
g |
0 |
1986 |
zakspeed 861 |
zakspeed s4 t / c |
g |
0 |
1987 |
zakspeed 861 zakspeed 871 |
zakspeed s4 t / c |
g |
2 |
1988 |
zakspeed 881 |
zakspeed s4 t / c |
g |
0 |
Prediction: TRUE
Ground-truth: TRUE