单项选择题
A. The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.
B. The statement returns an error at the SELECT clause.
C. The statement returns an error at the WHERE clause.
D. The statement returns an error at the ORDER BY clause.
单项选择题 Evaluate the SQL statement: What will be displayed?（）
单项选择题 The EMP table contains these columns: You need to display the employees who have not been assigned to any department. You write the SELECT statement: What is true about this SQL statement?（）
单项选择题 The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this?（）
