Statement: richmond hosted fitzroy at punt road oval
Input Table: 1946 vfl season
home_team | home_team_score | away_team | away_team_score | venue | crowd | date |
geelong | 15.7 (97) | melbourne | 21.14 (140) | kardinia park | 11500 | 1946-07-13 |
essendon | 16.24 (120) | footscray | 14.8 (92) | windy hill | 29000 | 1946-07-13 |
collingwood | 15.23 (113) | hawthorn | 11.14 (80) | victoria park | 11000 | 1946-07-13 |
carlton | 12.13 (85) | south melbourne | 11.18 (84) | princes park | 26000 | 1946-07-13 |
st kilda | 10.14 (74) | north melbourne | 12.11 (83) | junction oval | 7000 | 1946-07-13 |
richmond | 14.14 (98) | fitzroy | 10.12 (72) | punt road oval | 19000 | 1946-07-13 |
SQL Command:
SELECT
CASE
WHEN COUNT(*) = 0 THEN 'FALSE'
ELSE 'TRUE'
END
FROM table_sql
WHERE home_team = 'richmond'
AND venue = 'punt road oval'
AND away_team = 'fitzroy';