Step 1: Select rows where 'venue' is 'princes 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 'crowd' column to add column 'princes_park_crowd' to existing table.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
hawthorn |
19.24 (138) |
collingwood |
13.11 (89) |
princes park |
23830 |
1975-06-07 |
Step 3: Select rows where 'venue' is 'junction oval'.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
princes_park_crowd |
hawthorn |
19.24 (138) |
collingwood |
13.11 (89) |
princes park |
23830 |
1975-06-07 |
23830 |
Step 4: Extract the 'crowd' column to add column 'junction_oval_crowd' to existing table.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
princes_park_crowd |
Step 5: Use a `CASE` statement to return TRUE if the number of rows where 'princes_park_crowd' is equal to 'junction_oval_crowd' is equal to the number of rows, otherwise return FALSE.
home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
princes_park_crowd |
junction_oval_crowd |
Final output table:
verification_result |
FALSE |
Prediction: FALSE