Step 1: Select rows where 'team_1' is 'secteur 6'.
team_1 |
agg |
team_2 |
c_1st_leg |
c_2nd_leg |
al - merrikh |
2 - 2 (5 - 4 pen) |
tele sc asmara |
2 - 1 |
0 - 1 |
abaluhya united |
1 - 3 |
great olympics |
0 - 0 |
1 - 3 |
asc diaraf |
3 - 4 |
stade malien |
3 - 0 |
0 - 4 |
maseru united |
3 - 5 |
mmm tamatave |
1 - 2 |
2 - 3 |
as porto novo |
0 - 3 |
victoria club mokanda |
0 - 1 |
0 - 2 |
canon yaoundé |
9 - 4 |
as solidarité |
7 - 3 |
2 - 1 |
espérance |
1 - 0 |
al - ahly (benghazi) |
0 - 0 |
1 - 0 |
secteur 6 |
1 - 2 |
enugu rangers |
1 - 1 |
0 - 1 |
young africans |
2 - 0 |
lavori publici |
2 - 0 |
0 - 0 |
Step 2: Select rows where 'team_2' is 'enugu rangers'.
team_1 |
agg |
team_2 |
c_1st_leg |
c_2nd_leg |
secteur 6 |
1 - 2 |
enugu rangers |
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 |
secteur 6 |
1 - 2 |
enugu rangers |
1 - 1 |
0 - 1 |
Prediction: TRUE
Ground-truth: FALSE