Which statement finds students who have a grade point a…

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 *