【单选题】检索选修四门以上课程的学生总成绩 (不统计不及格的课程),并要求按总成绩的降序排列出来。
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”)
【简答题】受理站在接到旅客索赔要求时,应尽快做出赔偿决定,最迟在__天内将处理意见答复旅客。
【单选题】指出:“中国的命运与世界的命运紧密相关。我们要把弘扬爱国主义精神与扩大对外开放结合进来,尊重各国的历史特点、文化传统,尊重各国人民选择的发展道路,善于从不同文明中寻求智慧、汲取营养,增强中华文明生机活力。”这表明新时代的爱国主义( )。
【单选题】检索选修四门以上课程的学生总成绩,并要求按总成绩的降序排列出来。正确的SELECT语句是()。
A.
SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC GROUP BY SNO ORDER BY SUM_GRADE DESC HAVING COUNT(*) >= 4;
B.
SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC GROUP BY SNO HAVING COUNT(*)>=4 ORDER BY SUM_GRADE DESC;
C.
SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC HAVING COUNT(*)>=4 GROUP BY SNO ORDER BY SUM_GRADE DESC;
D.
SELECT SNO, SUM (GRADE) AS SUM_GRADE FROM SC ORDER BY SUM_GRADE DESC GROUP BY SNO HAVING COUNT(*)>=4;
【判断题】中间商与企业的合作诚意,应作为企业选择中间商的主要标准。( )