Statement: 3.8 (26) was the away team score against a home team that scored 5.12 (42)
Input Table: 1960 vfl season
home_team | home_team_score | away_team | away_team_score | venue | crowd | date |
north melbourne | 5.12 (42) | richmond | 3.8 (26) | arden street oval | 9000 | 1960-05-07 |
melbourne | 16.14 (110) | south melbourne | 6.10 (46) | mcg | 23135 | 1960-05-07 |
fitzroy | 5.11 (41) | geelong | 8.7 (55) | brunswick street oval | 13802 | 1960-05-07 |
hawthorn | 6.9 (45) | footscray | 6.17 (53) | glenferrie oval | 16000 | 1960-05-07 |
essendon | 11.10 (76) | collingwood | 11.8 (74) | windy hill | 30000 | 1960-05-07 |
st kilda | 5.11 (41) | carlton | 7.3 (45) | junction oval | 18700 | 1960-05-07 |
SQL Command:
SELECT
CASE
WHEN (SELECT away_team_score FROM table_sql WHERE home_team_score = '5.12 (42)' AND away_team_score = '3.8 (26)') IS NOT NULL
THEN 'TRUE'
ELSE 'FALSE'
END;