皮皮学，免费搜题
登录
搜题
【单选题】
基于这样的3个表,即学生表S.课程表C和学生选课表SC,它们的关系模式如下:S(S#,SN,SEX,AGE,DEPT)(学号,姓名,性别,年龄,系别)C(C#,CN)(课程号,课程名称)SC(S#,C#,GRADE)(学号,课程号,成绩).检索4门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是( )。A.
SELECT S#,SUM(GRAGE) FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY S# 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< /div>
D.
SELECT S#,SUM(GRADE) FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】Larry, Moe and Curly have capital balances of $100,000, $90,000 and $80,000 respectively. The partnership agreement states the profit-and-loss sharing ratio is: salaries of $10,000, $12,000 and $15,00...
A.
Larry $31,667; Moe $31,667 and Curly $31,666
B.
Larry $32,400; Moe $30,300 and Curly $32,300
C.
Larry $20,000; Moe $21,000 and Curly $23,000
D.
Larry $12,400; Moe $9,300 and Curly $9,300
【单选题】Suppose Larry, Moe and Curly are bidding in an auction for a mint-condition video of Charlie Chaplin's first movie. Each has in mind a maximum amount that he will bid. This maximum is called
A.
a resistance price.
B.
willingness to pay.
C.
consumer surplus.
D.
producer surplus.
【单选题】Larry, Moe and Curly have capital balances of $100,000, $90,000 and $80,000 respectively. The partnership agreement states the profit-and-loss sharing ratio is: salaries of $10,000, $12,000 and $15,00...
A.
Dr: Larry, capital 32,400 Dr: Moe, capital 30,300 Dr: Curly, capital 32,300 Cr: Income summary 95,000
B.
Dr: Income summary 95,000 Cr: Larry, capital 32,400 Cr: Moe, capital 30,300 Cr: Curly, capital 32,300
C.
Dr: Income summary 95,000 Cr: Larry, capital 31,667 Cr: Moe, capital 31,667 Cr: Curly, capital 31,666
D.
Dr: Larry, capital 31,667 Dr: Moe, capital 31,667 Dr: Curly, capital 31,666 Cr: Income summary 95,000
【单选题】Larry buys stock in FAST Express Company. Curly Corporation builds a new factory. Whose transaction would be an act of investment in the language of macroeconomics?
A.
only Larry's
B.
only Curly Corporation's
C.
Larry's and Curly Corporation's
D.
neither Larry's nor Curly Corporation's
【简答题】 典型的WAP应用系统定义了哪三类实体?
相关题目：