Step 1: Select rows where 'away_team' is 'footscray'.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
| geelong |
15.7 (97) |
melbourne |
21.14 (140) |
kardinia park |
11500 |
1946-07-13 |
| essendon |
16.24 (120) |
footscray |
14.8 (92) |
windy hill |
29000 |
1946-07-13 |
| collingwood |
15.23 (113) |
hawthorn |
11.14 (80) |
victoria park |
11000 |
1946-07-13 |
| carlton |
12.13 (85) |
south melbourne |
11.18 (84) |
princes park |
26000 |
1946-07-13 |
| st kilda |
10.14 (74) |
north melbourne |
12.11 (83) |
junction oval |
7000 |
1946-07-13 |
| richmond |
14.14 (98) |
fitzroy |
10.12 (72) |
punt road oval |
19000 |
1946-07-13 |
Step 2: Select rows where 'home_team' is 'essendon'.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
| essendon |
16.24 (120) |
footscray |
14.8 (92) |
windy hill |
29000 |
1946-07-13 |
Step 3: Select rows where 'date' is '1946-07-13'.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
| essendon |
16.24 (120) |
footscray |
14.8 (92) |
windy hill |
29000 |
1946-07-13 |
Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to 1, otherwise return FALSE.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
| essendon |
16.24 (120) |
footscray |
14.8 (92) |
windy hill |
29000 |
1946-07-13 |
Prediction: TRUE