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′ OR gpa > 3.;
B.
SELECT student_id, gpa
FROM student_grades
WHERE semester_end BETWEEN ’01-JAN-2001′
AND ’31-DEC-2001′ AND gpa gt 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.0;
E.
SELECT student_id, gpa
FROM student_grades
WHERE semester_end > ’01-JAN-2001′
OR semester_end < ’31-DEC-2001′ AND gpa >= 3.0;