The STUDENT_GRADES table has these columns: Which statement finds students who
have a grade point average (GPA) greater than 3.0 for the calendar year 2001?
A.
SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN
’01-JAN-2001’ AND ’31-DEC-2001’ AND gpa gt 3.0;
B.
SELECT student_id, gpa FROM student_grades WHERE semester_end > ’01-JAN-2001’
OR semester_end < ’31-DEC-2001’ AND gpa >= 3.0;
C.
SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN
’01-JAN-2001’ AND ’31-DEC-2001’ AND gpa > 3.0;
D.
SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN
’01-JAN-2001’ AND ’31-DEC-2001’ OR gpa > 3.;
E.
SELECT student_id, gpa FROM student_grades WHERE semester_end BETWEEN
’01-JAN-2001’ AND ’31-DEC-2001’ OR gpa > 3.0;