Step 1: Select rows where 'venue' is 'kardinia park'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
geelong |
14.20 (104) |
melbourne |
14.14 (98) |
kardinia park |
13328 |
1975-06-07 |
st kilda |
15.9 (99) |
north melbourne |
17.19 (121) |
moorabbin oval |
17811 |
1975-06-07 |
richmond |
19.14 (128) |
essendon |
12.9 (81) |
mcg |
49469 |
1975-06-07 |
hawthorn |
19.24 (138) |
collingwood |
13.11 (89) |
princes park |
23830 |
1975-06-07 |
fitzroy |
15.7 (97) |
carlton |
16.10 (106) |
junction oval |
16249 |
1975-06-07 |
footscray |
13.11 (89) |
south melbourne |
12.15 (87) |
vfl park |
14056 |
1975-06-07 |
Step 2: Select rows where 'venue' is 'moorabbin oval'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
geelong |
14.20 (104) |
melbourne |
14.14 (98) |
kardinia park |
13328 |
1975-06-07 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows for 'kardinia park' is less than the number of rows for 'moorabbin oval', otherwise return FALSE.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
Final output table:
verification_result |
FALSE |
Prediction: FALSE