Step 1: Select rows where 'team_1' is 'botswana defence force xi'.
| team_1 |
agg |
team_2 |
c_1st_leg |
c_2nd_leg |
| botswana defence force xi |
1 - 2 |
mbabane highlanders |
1 - 1 |
0 - 1 |
| arsenal (maseru) |
4 - 0 |
eleven arrows fc |
3 - 0 |
1 - 0 |
| cd elá nguema |
2 - 6 |
primeiro de agosto |
2 - 3 |
0 - 3 1 |
| lprc oilers |
2 - 3 |
mighty blackpool |
1 - 0 |
1 - 3 |
| asc police |
2 - 2 (4 - 5) |
as real bamako |
1 - 1 |
1 - 1 |
| port autonome |
0 - 0 (1 - 3) |
sporting clube da praia |
0 - 0 |
0 - 0 |
| saint - george sa |
2 - 4 |
al ittihad |
2 - 1 |
0 - 3 |
| saint - louis fc |
2 - 7 |
young africans |
1 - 3 |
1 - 4 |
| sahel sc |
4 - 2 |
postel sport |
2 - 1 |
2 - 1 |
| tourbillon fc |
1 - 1 |
forces armées ca |
0 - 0 |
1 - 1 |
Step 2: Select rows where 'team_2' is 'arsenal (maseru)'.
| team_1 |
agg |
team_2 |
c_1st_leg |
c_2nd_leg |
| botswana defence force xi |
1 - 2 |
mbabane highlanders |
1 - 1 |
0 - 1 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| team_1 |
agg |
team_2 |
c_1st_leg |
c_2nd_leg |
Final output table:
| verification_result |
| FALSE |
Prediction: FALSE