题目内容
（请给出正确答案）
A.S
B.SC，C
C.S，SC
D.S，C，SC
参考答案
简答题官方参考答案
（由简答题聘请的专业题库老师提供的解答）
网友提供的答案
更多“假定学生关系是S（S#，SN，SEX，AGE)，课程关系是C（C#，CN)，学生选课关系是SC（S#，C#，GRADE)。其中：S#为学号，SN为姓名，SEX为性别，AGE为年龄，C#为课程号，CN为…”相关的问题
A、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY Sgrade DESC
B、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY Sgrade
C、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY Sgrade DESC
D、SELECT S#,SUM(GRADE) as Sgrade FROM SC WHERE GRADE>=60 and COUNT(*)>=4 GROUP BY S# ORDER BY Sgrade DESC
A、其他都不对
B、
C、
D、
A、SELECT S#，SUM(GRADE) FORM SC GROUP BY S# HAVING COUNT(*)＞＝4;
B、SELECT S#，SUM(GRADE) FORM SC GROUP BY S# HAVING COUNT(*)＞＝4 ORDER BY SUM(GRADE) DESC;
C、SELECT S#，SUM(GRADE) FROM SC WHERE GRADE＞=60 GROUP BY S# HAVING COUNT(*)＞＝4 ORDER BY SUM(GRADE) DESC;
D、SELECT S#，SUM(GRADE) FROM SC GROUP BY S# HAVING GRADE＞=60 AND COUNT(*)＞＝4 ORDER BY SUM(GRADE) DESC;
A、SELECT SN，AGE，SEX FROM S WHERE AGE＞(SELECT AGE FROM S WHERE SN='王华');
B、SELECT SN，AGE，SEX FROM S WHERE SN＝“王华';
C、SELECT SN，AGE，SEX FROM S WHERE AGE＞(SELECT AGE WHERE SN='王华');
D、SELECT SN，AGE，SEX FROM S WHERE AGE＞王华.AGE;
警告：系统检测到您的账号存在安全风险
为了保护您的账号安全，请在“简答题”公众号进行验证，点击“官网服务”-“账号验证”后输入验证码“”完成验证，验证成功后方可继续查看答案！
XM,DWH(
XB='女'(R))的SQL语句是( )。
