皮皮学，免费搜题
登录
搜题
【单选题】
The day on which Thanksgiving is observed now was first selected by ______A.
President George Washington
B.
President Abraham Lincoln
C.
President Franklin
D.
Roosevelt D.Congress
手机使用
分享
复制链接
新浪微博
分享QQ
微信扫一扫
反馈参考答案：
举一反三
【简答题】根据首字母的提示完成短文， 每空一词。 Some western countries insist that China is one of the world's biggest greenhouse gas emitters (温室气 体排放者). But in f______ (1) our government has taken actions actively to struggle ...
【单选题】假设有scores表的设计如下: ID(编号,主键) StudentID(学生编号) CourseID(课程编号) Score(分数) 现在要查询参加过至少两门课程考试的学生各门课程的平均成绩。以下SQL语句正确的是()。
A.
select StudentID,avg(score) from scores group by StudentID having count(studentID)>1
B.
select StudentID,avg(score) from scores group by StudentID where count(studentID)>1
C.
select StudentID,avg(score) from scores group by StudentID where count(studentID)>1 group by StudentID
D.
select StudentID,avg(score) from scores having count(studentID)>1
【简答题】He is considered to be one of the best romantic poets in China . 译: ______________________________________________________
【单选题】假设有 scores 表的设计如下：ID（编号，主键）、StudentID （学生编号）、CourseID （课程编号）、Score （分数），现在要查询参加过至少两门课程考试的学生各门课程的平均成绩。以下SQL 语句正确的是
A.
select StudentID，avg(score) from scores group by StudentID having count(studentID)>1
B.
select StudentID，avg(score) from scores group by StudentID where count(studentID)>1
C.
select StudentID，avg(score) from scores group by StudentID where count(studentID)>1 group by StudentID
D.
D.select StudentID，avg(score) from scores having count(studentID)>1
相关题目：
参考解析：
知识点：
题目纠错 0
发布
