Step 1: Select rows where 'venue' is 'moorabbin oval' or '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: Extract the numerical value from the 'crowd' column to add column 'num_crowd' to existing table.
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 |
Step 3: Cast to INT and order the table by 'num_crowd' in ascending order and select the first row.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
num_crowd |
geelong |
14.20 (104) |
melbourne |
14.14 (98) |
kardinia park |
13328 |
1975-06-07 |
13328 |
st kilda |
15.9 (99) |
north melbourne |
17.19 (121) |
moorabbin oval |
17811 |
1975-06-07 |
17811 |
Step 4: Select rows where 'venue' is 'moorabbin oval'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
num_crowd |
geelong |
14.20 (104) |
melbourne |
14.14 (98) |
kardinia park |
13328 |
1975-06-07 |
13328 |
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 |
num_crowd |
Final output table:
verification_result |
FALSE |
Prediction: FALSE
Ground-truth: FALSE