The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) Which statement finds the highest grade point average (GPA) per semester?（）
A. SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL; B. SELECT (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL; C. SELECT MAX (gpa) FROM student _ grades WHERE gpa IS NOT NULL GROUP BY semester_end; D. SELECT MAX (gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student _ grades; E. SELECT MAX (gpa) FROM student _ grades GROUP BY semester_end WHERE gpa IS NOT NULL;
A. Group functions on columns ignore NULL values. B. Group functions on columns returning dates include NULL values. C. Group functions on columns returning numbers include NULL values. D. Group functions on columns cannot be accurately used on columns that contain NULL values. E. Group functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
A. none B. DELETE, INSERT,SELECT C. ALTER, DELETE, INSERT, SELECT D. DELETE, INSERT, SELECT, UPDATE
微信掃一掃關(guān)注公眾號(hào)后聯(lián)系客服
微信掃碼免費(fèi)搜題
