Step 1: Select rows where 'home_team' is 'melbourne'.
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 'away_team' is 'adelaide'.
home_team |
home_team_score |
away_team |
away_team_score |
ground |
crowd |
date |
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 |
ground |
crowd |
date |