Step 1: Select rows where the 'wins' column is greater than 0.
season |
series |
team |
races |
wins |
poles |
f___laps |
podiums |
points |
position |
2007 |
formula renault 2.0 italy |
bvm minardi team |
14 |
0 |
0 |
0 |
1 |
106 |
14th |
2007 |
eurocup formula renault 2.0 |
bvm minardi team |
6 |
0 |
0 |
0 |
0 |
n / a |
nc |
2007 |
formula renault 2.0 italy - winter series |
bvm minardi team |
4 |
4 |
4 |
4 |
4 |
144 |
1st |
2008 |
formula renault 2.0 italy |
bvm minardi team |
14 |
0 |
1 |
2 |
4 |
216 |
6th |
2008 |
eurocup formula renault 2.0 |
bvm minardi team |
14 |
0 |
0 |
0 |
1 |
38 |
7th |
2009 |
formula 3 euro series |
manor motorsport |
16 |
0 |
0 |
0 |
0 |
0 |
25th |
2009 |
masters of formula 3 |
manor motorsport |
1 |
0 |
0 |
0 |
0 |
n / a |
28th |
2010 |
italian formula three championship |
bvm - target racing |
16 |
3 |
2 |
7 |
8 |
161 |
1st |
2011 |
formula renault 3.5 series |
s fortec motorsport |
17 |
0 |
2 |
0 |
0 |
47 |
11th |
Step 2: Use a `CASE` statement to return TRUE if the number of rows is equal to the number of unique teams in the table, otherwise return FALSE.
season |
series |
team |
races |
wins |
poles |
f___laps |
podiums |
points |
position |
2007 |
formula renault 2.0 italy - winter series |
bvm minardi team |
4 |
4 |
4 |
4 |
4 |
144 |
1st |
2010 |
italian formula three championship |
bvm - target racing |
16 |
3 |
2 |
7 |
8 |
161 |
1st |