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. 饶阳金丝杂面
B. 藁城宫面
C. 白洋淀松花蛋
D. 高碑店豆腐丝
保定槐茂酱菜被()赐名“太平菜”
A. 康熙
B. 慈禧
C. 雍正
D. 乾隆
在()和其他领域的教育活动中努力渗透语言教育。
A. 一日生活的各个环节中
B. 专门的语言教育活动中
C. 家庭中
D. 体育活动中