Step 1: Select rows where 'chassis' is 'maserati 250f'.
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 |
Step 2: Select rows where 'engine' is 'climax straight - 4'.
year |
entrant |
chassis |
engine |
points |
1956 |
bruce halford |
maserati 250f |
maserati straight - 6 |
0 |
1957 |
bruce halford |
maserati 250f |
maserati straight - 6 |
0 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is greater than or equal to 1, otherwise return FALSE.
year |
entrant |
chassis |
engine |
points |