Statement: on march 19 , 1984 , plymouth argyle played derby county
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 COUNT(*) = 0 THEN 'FALSE'
ELSE 'TRUE'
END
FROM table_sql
WHERE date = '1984-03-19'
AND (home_team = 'plymouth argyle' OR away_team = 'plymouth argyle')
AND (home_team = 'derby county' OR away_team = 'derby county');