Statement: fitzroy has a higher score than any of the other teams
Input Table: 1975 vfl season
home_team | home_team_score | away_team | away_team_score | venue | crowd | date |
geelong | 14.20 (104) | melbourne | 14.14 (98) | kardinia park | 13328 | 1975-06-07 |
st kilda | 15.9 (99) | north melbourne | 17.19 (121) | moorabbin oval | 17811 | 1975-06-07 |
richmond | 19.14 (128) | essendon | 12.9 (81) | mcg | 49469 | 1975-06-07 |
hawthorn | 19.24 (138) | collingwood | 13.11 (89) | princes park | 23830 | 1975-06-07 |
fitzroy | 15.7 (97) | carlton | 16.10 (106) | junction oval | 16249 | 1975-06-07 |
footscray | 13.11 (89) | south melbourne | 12.15 (87) | vfl park | 14056 | 1975-06-07 |
SQL Command:
SELECT
CASE
WHEN (SELECT MAX(home_team_score) FROM table_sql) >
(SELECT MAX(away_team_score) FROM table_sql)
AND (SELECT MAX(home_team_score) FROM table_sql) >
(SELECT MAX(away_team_score) FROM table_sql WHERE home_team != 'fitzroy')
AND (SELECT MAX(home_team_score) FROM table_sql) >
(SELECT MAX(away_team_score) FROM table_sql WHERE home_team != 'fitzroy' AND away_team != 'fitzroy')
THEN 'TRUE'
ELSE 'FALSE'
END;