Step 1: Select rows where 'player' is 'george evans'.
rank |
player |
years |
games |
reb_avg |
total_rebounds |
1 |
jim nowers |
1972 - 1976 |
112 |
9.4 |
1048 |
2 |
kenny sanders |
1985 - 1989 |
107 |
9.6 |
1026 |
3 |
will thomas |
2004 - 2008 |
131 |
7.6 |
993 |
4 |
george evans |
1997 - 2001 |
116 |
8.2 |
953 |
5 |
robert dykes |
1987 - 1991 |
122 |
7.5 |
925 |
6 |
andre gaddy |
1977 - 1982 |
98 |
9.3 |
916 |
7 |
jai lewis |
2002 - 2006 |
125 |
7.2 |
895 |
8 |
rob rose |
1982 - 1986 |
113 |
7.1 |
805 |
9 |
herb estes |
1973 - 1976 |
80 |
9.2 |
734 |
10 |
jesse young |
1999 - 2003 |
115 |
6.2 |
708 |
Step 2: Select rows where 'rank' is greater than 8.
rank |
player |
years |
games |
reb_avg |
total_rebounds |
4 |
george evans |
1997 - 2001 |
116 |
8.2 |
953 |
Step 3: Use a `CASE` statement to return TRUE if the number of rows is equal to 0, otherwise return FALSE.
rank |
player |
years |
games |
reb_avg |
total_rebounds |
Prediction: TRUE