|
Explanation: : for highest gpa value MAX function is needed, for result with per semester GROUP BY clause is needed Incorrect answer : 1: per semester condition is not included 2: result would not display the highest gpa value 4: invalid syntax error 5: invalid syntax error Reference: Introduction to Oracle9i : SQL, Oracle University Study Guide, 5-7
|