Statement: 21.16 (142) home team score had a away team of fitzroy
Input Table: 1982 vfl season
home_team | home_team_score | away_team | away_team_score | venue | crowd | date |
footscray | 7.8 (50) | richmond | 16.16 (112) | western oval | 16259 | 1982-08-07 |
fitzroy | 21.16 (142) | st kilda | 11.12 (78) | junction oval | 9987 | 1982-08-07 |
north melbourne | 22.18 (150) | geelong | 11.16 (82) | arden street oval | 11634 | 1982-08-07 |
hawthorn | 20.20 (140) | collingwood | 16.22 (118) | princes park | 18699 | 1982-08-07 |
essendon | 20.17 (137) | melbourne | 14.17 (101) | vfl park | 28379 | 1982-08-07 |
swans | 15.16 (106) | carlton | 9.18 (72) | scg | 25601 | 1982-08-01 |
SQL Command:
SELECT
CASE
WHEN (SELECT home_team_score FROM table_sql WHERE home_team = 'fitzroy') = '21.16 (142)'
THEN 'TRUE'
ELSE 'FALSE'
END;