【单选题】有三个表,即学生表S、课程表C和学生选课表SC,它们的结构 如下:S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中,S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程 号,CN为课程名,GRADE为成绩。要检索选修 4 门以上课程的学生总成绩(不统计不及格的课程),并要求按 总成绩的降序排列出来。正确的 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
【单选题】有三个表,即学生表S、课程表C和学生选课表SC,它们的结构如下:S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中,S#为学号,SN为姓名,SEX为性别,AGE为年龄,DEPT为系别,C#为课程 号,CN为课程名,GRADE为成绩。检索选修 4 门以上课程的学生总成绩(不统计不及格的课程),并要求按 总成绩的降序排列出来。正确的 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
【单选题】基于这样的三个表,即学生表 S、课程表 C 和学生选课表 SC,它们的结构 如下:S(S#,SN,SEX,AGE,DEPT)C(C#,CN)SC(S#,C#,GRADE)其中,S#为学号,SN 为姓名,SEX 为性别,AGE 为年龄,DEPT 为系别,C#为课程 号,CN 为课程名,GRADE 为成绩。检索选修 4 门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的...
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
【简答题】年终决算后,“本年利润”账户与“利润分配”账户都没有期末余额。 ( )
【单选题】中国共产党在发展问题上的经验总结和思想结晶是
【单选题】给家兔静脉注射去甲肾上腺素后动脉血压升高,肾小球滤过率和尿量迅速减少,该动物肾小球滤过率降低的主要原因是
【单选题】中国共产党在发展问题上的经验总结和思想结晶是( )
【简答题】将本年亏损30 000元转入利润分配账户(要求写出利润分配账户的明细账户)。
【单选题】损益类账户在期末结账后应无余额,其发生额应转入( )。
【单选题】2 4 .各损益类账户期末应结转至( ) 账户中。