Step 1: Calculate the average of the 'home_team_score' column then add column 'avg_home_team_score' to the existing table.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
| footscray |
14.7 (91) |
st kilda |
9.11 (65) |
western oval |
18655 |
1972-07-15 |
| fitzroy |
16.14 (110) |
north melbourne |
9.12 (66) |
junction oval |
7007 |
1972-07-15 |
| essendon |
13.12 (90) |
richmond |
17.9 (111) |
windy hill |
22251 |
1972-07-15 |
| carlton |
20.8 (128) |
south melbourne |
8.15 (63) |
princes park |
14465 |
1972-07-15 |
| hawthorn |
19.14 (128) |
geelong |
15.8 (98) |
glenferrie oval |
12425 |
1972-07-15 |
| collingwood |
10.13 (73) |
melbourne |
8.10 (58) |
vfl park |
30883 |
1972-07-15 |
Step 2: Select rows where 'avg_home_team_score' is equal to 15.67.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
avg_home_team_score |
| footscray |
14.7 (91) |
st kilda |
9.11 (65) |
western oval |
18655 |
1972-07-15 |
103.33333333333333 |
| fitzroy |
16.14 (110) |
north melbourne |
9.12 (66) |
junction oval |
7007 |
1972-07-15 |
103.33333333333333 |
| essendon |
13.12 (90) |
richmond |
17.9 (111) |
windy hill |
22251 |
1972-07-15 |
103.33333333333333 |
| carlton |
20.8 (128) |
south melbourne |
8.15 (63) |
princes park |
14465 |
1972-07-15 |
103.33333333333333 |
| hawthorn |
19.14 (128) |
geelong |
15.8 (98) |
glenferrie oval |
12425 |
1972-07-15 |
103.33333333333333 |
| collingwood |
10.13 (73) |
melbourne |
8.10 (58) |
vfl park |
30883 |
1972-07-15 |
103.33333333333333 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is greater than or equal to 1, otherwise return FALSE.
| home_team |
home_team_score |
away_team |
away_team_score |
venue |
crowd |
date |
avg_home_team_score |
| verification_result |
| FALSE |