【单选题】检索选修四门以上课程的学生总成绩 (不统计不及格的课程),并要求按总成绩的降序排列出来。
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 S#, SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)>=4
B.
SELECT S#, SUM(GRADE) FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESC
C.
SELECT S#, SUM(GRADE) FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC
D.
SELECT S#, SUM(GRADE)FROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4
【单选题】习近平总书记指出:“中国的命运与世界的命运紧密相关。我们要把弘扬爱国主义精神与扩大对外开放结合进来,尊重各国的历史特点、文化传统,尊重各国人民选择的发展道路,善于从不同文明中寻求智慧、汲取营养,增强中华文明生机活力。”这表明新时代的爱国主义( )。
【多选题】有关债务重组的基本特征表述正确的是( )。
A.
债务重组是指在债务人发生财务困难的情况下,债权人按照其与债务人达成的协议或者法院的裁定做出让步的事项
B.
债务人发生财务困难”,是指因债务人出现资金周转困难、经营陷入困境或者其他方面的原因等,导致其无法或者没有能力按原定条件偿还债务的情况
C.
“债权人做出让步”,是指债权人同意发生财务困难的债务人现在或者将来以低于重组债务账面价值的金额或者价值偿还债务
D.
“债权人做出让步”的情形主要包括:债权人减免债务人部分债务本金或者利息、降低债务人应付债务的利率等
【单选题】检索选修四门以上课程的学生总成绩,并要求按总成绩的降序排列出来。正确的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;
【判断题】中间商与企业的合作诚意,应作为企业选择中间商的主要标准。( )