题目内容

scores表设计如下，查询平均成绩大于85的学生信息的正确SQL语句是（）

A. select * from student where Score in （ select sno , avg（Score） from scores group by sno Having avg（Score） >85 ）;
B. select * from student where sno in （ select sno from scores group by sno Having avg（Score） >85 ）;
C. select * from student where sno in （ select sno, avg（Score） from scores where avg（Score） >85 ）;
D. select * from student where sno in （ select avg（Score） from scores group by sno Having avg（Score） >85 ）;

查看答案

搜索结果不匹配？点我反馈

更多问题

course表设计如下：查询所有学分大于3分的课程名称。正确SQL语句是（）

A. select * from course where grade >3;
B. select cname from Sourse where grade >3;
C. select cname from course where grade >3
D. select cno from course where grade >3;

查看答案

course表设计如下，查询所有的课程信息，并按学分的由高到低排序显示。正确SQL语句是（）

A. select * from course order by grade ;
B. select * from course order by grade desc;
C. select * , grade from Sourse order by grade desc;
D. select * , grade from course order by grade asc ;

查看答案

course表设计如下：查询所有的课程信息，并按学分的由低到高排序显示。正确SQL语句是（）

A. select * from course order by grade;
B. select * , grade from Sourse order by grade asc;
C. select * , grade from course order by grade;
D. select * , grade from course order by grade desc;

查看答案

course表设计如下，查询所有学分在3-5分之间的课程名称的正确SQL语句是（）

A. select cname from course where grade on （3,5）;
B. select cname from course where grade >= 3 and grade <= 5;
C. select cno from course where grade >= 3 and grade <= 5;
D. select cname from course where 3<=grade<=5;

查看答案