Step 1: Select rows where the 'chassis' is 'lotus 16', 'cooper t45', or 'cooper t51'.
| 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 the 'engine' is 'climax straight - 4'.
| year |
entrant |
chassis |
engine |
points |
| 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 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 3, otherwise return FALSE.
| year |
entrant |
chassis |
engine |
points |
| 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 |