Statement: the score of the sheffield wednesday versus southampton game was 0 - 0
Input Table: 1983 - 84 fa cup
tie_no | home_team | score | away_team | date |
1 | notts county | 1 - 2 | everton | 1984-03-10 |
2 | sheffield wednesday | 0 - 0 | southampton | 1984-03-11 |
replay | southampton | 5 - 1 | sheffield wednesday | 1984-03-20 |
3 | plymouth argyle | 0 - 0 | derby county | 1984-03-10 |
replay | derby county | 0 - 1 | plymouth argyle | 1984-03-14 |
4 | birmingham city | 1 - 3 | watford | 1984-03-10 |
SQL Command:
SELECT
CASE
WHEN (SELECT score FROM table_sql WHERE home_team = 'sheffield wednesday' AND away_team = 'southampton') = '0 - 0'
OR (SELECT score FROM table_sql WHERE home_team = 'southampton' AND away_team = 'sheffield wednesday') = '0 - 0'
THEN 'TRUE'
ELSE 'FALSE'
END;