Step 1: Select rows where 'home_team' is 'carlton'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
geelong |
16.14 (110) |
hawthorn |
14.11 (95) |
kardinia park |
31569 |
1969-08-23 |
collingwood |
19.15 (129) |
south melbourne |
6.22 (58) |
victoria park |
19428 |
1969-08-23 |
carlton |
20.7 (127) |
richmond |
24.12 (156) |
princes park |
27657 |
1969-08-23 |
st kilda |
21.18 (144) |
north melbourne |
8.10 (58) |
moorabbin oval |
11109 |
1969-08-23 |
melbourne |
14.13 (97) |
fitzroy |
14.15 (99) |
mcg |
17790 |
1969-08-23 |
footscray |
14.10 (94) |
essendon |
12.10 (82) |
western oval |
16043 |
1969-08-23 |
Step 2: Select rows where 'away_team' is 'richmond'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
carlton |
20.7 (127) |
richmond |
24.12 (156) |
princes park |
27657 |
1969-08-23 |
Step 3: Select rows where 'venue' is 'princes park'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
carlton |
20.7 (127) |
richmond |
24.12 (156) |
princes park |
27657 |
1969-08-23 |
Step 4: Select rows where 'home_team_score' is '20.7 (127)'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
carlton |
20.7 (127) |
richmond |
24.12 (156) |
princes park |
27657 |
1969-08-23 |
Step 5: 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 |
20.7 (127) |
richmond |
24.12 (156) |
princes park |
27657 |
1969-08-23 |
Prediction: TRUE