Statement: climax straight - 4 has lotus 16 , cooper t45 , and cooper t51 chassis
Input Table: bruce halford
year | entrant | chassis | engine | points |
1956 | bruce halford | maserati 250f | maserati straight - 6 | 0 |
1957 | bruce halford | maserati 250f | maserati straight - 6 | 0 |
1959 | john fisher | lotus 16 | climax straight - 4 | 0 |
1960 | fred tuck cars | cooper t45 | climax straight - 4 | 0 |
1960 | yeoman credit racing team | cooper t51 | climax straight - 4 | 0 |
SQL Command:
SELECT
CASE
WHEN COUNT(*) = 3 THEN 'TRUE'
ELSE 'FALSE'
END
FROM table_sql
WHERE engine = 'climax straight - 4'
AND (chassis = 'lotus 16' OR chassis = 'cooper t45' OR chassis = 'cooper t51');