Statement: melbourne was the home team when the teams met at adelaide
Input Table: 2000 ansett australia cup
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 |
SQL Command:
SELECT
CASE
WHEN COUNT(*) = 0 THEN 'FALSE'
ELSE 'TRUE'
END
FROM table_sql
WHERE home_team = 'melbourne'
AND ground = 'adelaide';