Step 1: Select rows where 'home_team' is 'birmingham city'.
| tie_no |
home_team |
score |
away_team |
date |
| 1 |
notts county |
1 - 2 |
everton |
1984-03-10 |
| 2 |
sheffield wednesday |
0 - 0 |
southampton |
1984-03-11 |
| replay |
southampton |
5 - 1 |
sheffield wednesday |
1984-03-20 |
| 3 |
plymouth argyle |
0 - 0 |
derby county |
1984-03-10 |
| replay |
derby county |
0 - 1 |
plymouth argyle |
1984-03-14 |
| 4 |
birmingham city |
1 - 3 |
watford |
1984-03-10 |
Step 2: Select rows where 'date' is '1984-03-10'.
| tie_no |
home_team |
score |
away_team |
date |
| 4 |
birmingham city |
1 - 3 |
watford |
1984-03-10 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| tie_no |
home_team |
score |
away_team |
date |
| 4 |
birmingham city |
1 - 3 |
watford |
1984-03-10 |
Prediction: TRUE