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;
微信支付 
支付宝支付