Step 1: Select rows where 'type_of_game' is '1982 wcq'.
date |
city |
opponent |
results |
type_of_game |
9999-03-22 |
sarajevo |
uruguay |
2:1 |
friendly |
9999-03-30 |
belgrade |
romania |
2:0 |
balkan cup |
9999-04-26 |
borovo |
poland |
2:1 |
friendly |
9999-08-27 |
bucharest , romania |
romania |
1:4 |
balkan cup |
9999-09-10 |
luxembourg |
luxembourg |
5:0 |
1982 wcq |
9999-09-27 |
ljubljana |
denmark |
2:1 |
1982 wcq |
9999-11-15 |
torino , italy |
italy |
0:2 |
1982 wcq |
Step 2: Select rows where 'results' is '0:2'.
date |
city |
opponent |
results |
type_of_game |
9999-09-10 |
luxembourg |
luxembourg |
5:0 |
1982 wcq |
9999-09-27 |
ljubljana |
denmark |
2:1 |
1982 wcq |
9999-11-15 |
torino , italy |
italy |
0:2 |
1982 wcq |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
date |
city |
opponent |
results |
type_of_game |
9999-11-15 |
torino , italy |
italy |
0:2 |
1982 wcq |
Prediction: TRUE