Step 1: Select rows where 'home_team' is 'carlton'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
footscray |
10.6 (66) |
melbourne |
10.13 (73) |
western oval |
11000 |
1927-09-10 |
carlton |
15.16 (106) |
st kilda |
7.9 (51) |
princes park |
24000 |
1927-09-10 |
richmond |
16.23 (119) |
hawthorn |
6.17 (53) |
punt road oval |
11000 |
1927-09-10 |
south melbourne |
14.11 (95) |
geelong |
15.15 (105) |
lake oval |
15000 |
1927-09-10 |
fitzroy |
5.13 (43) |
essendon |
14.10 (94) |
brunswick street oval |
11000 |
1927-09-10 |
north melbourne |
7.14 (56) |
collingwood |
11.16 (82) |
arden street oval |
11000 |
1927-09-10 |
Step 2: Select rows where 'away_team' is 'st kilda'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
carlton |
15.16 (106) |
st kilda |
7.9 (51) |
princes park |
24000 |
1927-09-10 |
Step 3: Select rows where 'venue' is 'princes park'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
carlton |
15.16 (106) |
st kilda |
7.9 (51) |
princes park |
24000 |
1927-09-10 |
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 |
carlton |
15.16 (106) |
st kilda |
7.9 (51) |
princes park |
24000 |
1927-09-10 |
Prediction: TRUE
Ground-truth: TRUE