Which statement finds students who have a grade point average (GPA) greater than 3.0 for the calendar year 2001?

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?

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;



Leave a Reply 0

Your email address will not be published. Required fields are marked *