皮皮学，免费搜题
登录
搜题
【单选题】
用SQL语言检索选修课程在5门以上(含5门)的学号、姓名和平均成绩，并按平均成绩降序排序，正确的命令是A.
SELECT S.学号，姓名，平均成绩FROM S，SC； WHERE S.学号=SC.学号； GROUP BY S.学号 HAVING COUNT(*)＞＝5 ORDER BY 平均成绩 DESC
B.
SELECT 学号，姓名，AVG(成绩)FROM S，SC； WHERE S.学号=SC.学号AND COUNT(*)＞＝5； GROUP BY 学号 ORDER BY 3 DESC
C.
SELECT S.学号，姓名，AVG(成绩)平均成绩 FROM S，SC； WHERE S.学号=SC.学号AND COUNT(*)＞＝5； GROUP BY S.学号 ORDER BY平均成绩 DESC
D.
SELECT S.学号，姓名，AVG(成绩)平均成绩 FROM S，SC； WHERE S.学号；SC，学号； GROUP BY S.学号 HAVING COUNT(*)＞＝5 ORDER BY 3 DESC
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【简答题】已知m 2 +mn+2n 2 =11，mn+n 2 =6，则m 2 +n 2 的值为（ ）。
【单选题】When playing a game you should ask your child to find something starting with the letter b instead Of c．
A.
Right
B.
Wrong
C.
Not mentioned
【单选题】When playing a game you should ask your child to find something starting with the letter b instead of c.（ ）
A.
Right
B.
Wrong
C.
Not mentioned
【单选题】听力原文： There are four types of college degrees, starting with the associate degree. The associate takes about two years to complete when one is enrolled full time. The bachelor's degree takes four year...
A.
The Bachelor's degree.
B.
The Associate degree.
C.
The Master's degree.
D.
The Doctor's degree.
【简答题】When playing a you should ask your child to find something starting with the letter b instead of c.
【单选题】利用配方法解方程x 2 -12x+25=0可得到下列哪一个方程（ ）
A.
（x+6） 2 =11
B.
（x-6） 2 =-11
C.
（x-6） 2 =11
D.
（x+6） 2 =51
【单选题】听力原文： There are four types of college degrees, starting with the associate degree. The associate takes about two years to complete when one is enrolled full time. The bachelor's degree takes four year...
A.
The Bachelor's degree.
B.
The Associate degree.
C.
The Master's degree.
D.
The Doctor's degree.
相关题目：
【单选题】利用配方法解方程x 2 -12x+25=0可得到下列哪一个方程（ ）
A.
（x+6） 2 =11
B.
（x-6） 2 =-11
C.
（x-6） 2 =11
D.
（x+6） 2 =51