Step 1: Select rows where the 'home_team' is 'adelaide'.
| home_team |
home_team_score |
away_team |
away_team_score |
ground |
crowd |
date |
| adelaide |
17.5 (107) |
melbourne |
19.11 (125) |
football park |
12239 |
9999-01-30 |
| geelong |
10.14 (74) |
st kilda |
11.12 (78) |
waverley park |
7394 |
9999-01-30 |
| st kilda |
9.12 (66) |
melbourne |
13.14 (92) |
waverley park |
10533 |
9999-02-05 |
| adelaide |
19.10 (124) |
geelong |
15.12 (102) |
football park |
11326 |
9999-02-06 |
| adelaide |
14.11 (95) |
st kilda |
15.12 (102) |
football park |
13086 |
9999-02-13 |
| geelong |
17.12 (114) |
melbourne |
11.16 (82) |
waverley park |
4952 |
01-14-9999 |
Step 2: Select rows where the 'home_team_score' is '17.5 (107)'.
| home_team |
home_team_score |
away_team |
away_team_score |
ground |
crowd |
date |
| adelaide |
17.5 (107) |
melbourne |
19.11 (125) |
football park |
12239 |
9999-01-30 |
| adelaide |
19.10 (124) |
geelong |
15.12 (102) |
football park |
11326 |
9999-02-06 |
| adelaide |
14.11 (95) |
st kilda |
15.12 (102) |
football park |
13086 |
9999-02-13 |
Step 3: Select rows where the 'date' is '9999-01-30'.
| home_team |
home_team_score |
away_team |
away_team_score |
ground |
crowd |
date |
| adelaide |
17.5 (107) |
melbourne |
19.11 (125) |
football park |
12239 |
9999-01-30 |
Step 4: 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 |
ground |
crowd |
date |
| adelaide |
17.5 (107) |
melbourne |
19.11 (125) |
football park |
12239 |
9999-01-30 |