原标题： 2021年国家电网学校招聘计算机专业练习题：检索选修

检索选修四门以上课程的学生总成绩(不计算不及格的课程)，并要求按总成绩的降序摆放出来。正确的SELECt句子是 。

A．SELECT S#，SUM(GRADE)FROM SC

WHERe GRADE＞=60

GROUP BY S#

ORDER BY 2 DESC

HAVINg COUNT(*)＞＝4 WHERe C#=“C2” AND GRADE＞＝

(SELECT GRADE FORM SC

WHERe C#=“C2”)

B．SELECT S# FORM SC

WHERe C#=“C2” AND GRADE IN

(SELECT GRADE FORM SC

WHERe C#=“C2”)

C．SELECT S# FORM SC

WHERe C#=“C2” AND GRADE NOT IN

(SELECT GRADE FORM SC

WHERe C#=“C2”)

D．SELECT S# FORM SC

WHERe C#=“C2” AND GRADE＞＝ALL

(SELECT GRADE FORM SC

WHERe C#=“C2”)

责任编辑：