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;
student表设计如下，查询所有年龄在18-25岁之间的学生姓名和性别的正确SQL语句是（）
A. select sname ,sex from student where （year（getdate（））-YEAR（birth））>=18 and （year（getdate（））-YEAR（birth））<=25;
B. select sname ,sex from student where birth between 18 and 25;
C. select sname ,sex from student where YEAR<=1997 and YEAR>=1990;
D. select sname ,sex from student where birth in （1997,1990）;
微信支付 
支付宝支付