The STUDENT_GRADES table has these columns: STUDENT_IDNUMBER(12)
SEMESTER_ENDDATE GPANUMBER(4,3) The registrar has asked for a report on the
average grade point average (GPA), sorted from the highest grade point average to each
semester, starting from the earliest date. Which statement accomplish this?
A.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,
semester_end ASC;
B.
SELECT student_id,semester_end,gpa FROM student_grades ORDER BY
semester_end,gpa DESC
C.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,
semester_end DESC;
D.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY
semester_end, gpa ASC
E.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY
semester_end DESC, gpa DESC;
F.
SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,
semester_end ASC;
A is correct.
Question ask “sorted from the highest grade point average to each
semester, starting from the earliest date”
B start from the oldest date.
A is incorrect. At first you have to order by semester_end and then by gpa.
B is correct answer as earlier = oldest date first.
Option D is correct. Not B.
As it will sort semester_end in ASC order by default.
Or you have to write like Semester_end Desc . As we wrote in Option D.
B is correct.