Step 1: Select rows where 'venue' is 'lake oval' or 'glenferrie oval'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
north melbourne |
9.14 (68) |
st kilda |
11.16 (82) |
arden street oval |
13000 |
1961-06-03 |
hawthorn |
10.13 (73) |
richmond |
8.12 (60) |
glenferrie oval |
15000 |
1961-06-03 |
collingwood |
18.11 (119) |
essendon |
8.10 (58) |
victoria park |
28290 |
1961-06-03 |
geelong |
13.13 (91) |
footscray |
4.14 (38) |
kardinia park |
18683 |
1961-06-03 |
south melbourne |
7.8 (50) |
fitzroy |
17.15 (117) |
lake oval |
14500 |
1961-06-03 |
melbourne |
15.14 (104) |
carlton |
11.13 (79) |
mcg |
49678 |
1961-06-03 |
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 |
hawthorn |
10.13 (73) |
richmond |
8.12 (60) |
glenferrie oval |
15000 |
1961-06-03 |
south melbourne |
7.8 (50) |
fitzroy |
17.15 (117) |
lake oval |
14500 |
1961-06-03 |
Step 3: Cast to INT and order the table by 'num_crowd' in descending order and select the first row.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
num_crowd |
hawthorn |
10.13 (73) |
richmond |
8.12 (60) |
glenferrie oval |
15000 |
1961-06-03 |
15000 |
south melbourne |
7.8 (50) |
fitzroy |
17.15 (117) |
lake oval |
14500 |
1961-06-03 |
14500 |
Step 4: Select rows where 'venue' is 'lake oval'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
num_crowd |
hawthorn |
10.13 (73) |
richmond |
8.12 (60) |
glenferrie oval |
15000 |
1961-06-03 |
15000 |
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