Statement: the score for the game where birmingham city was the home team on 10 march 1984 was 1 - 3
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 score = '1 - 3' AND home_team = 'birmingham city' AND date = '1984-03-10'
THEN 'TRUE'
ELSE 'FALSE'
END
FROM table_sql;