_____ is the most important river in Scotland（）
A. The Clyde River （克莱德河）
B. River Thames
C. The Severn
D. River Kennet
查看答案
What is the Glasgow’s top attraction（）
A. The John Rylands Library
B. National Football Museum
City Town Hall
D. Burrell Collection
在学生选课数据库中，查询平均成绩大于等于60分的同学，SQL语句为（）
A. SELECT Sno, AVG（Grade） FROM SC GROUP BY Sno HAVING AVG（Grade）＞=60;
B. SELECT Sno FROM SC WHERE Grade＞=60 GROUP BY Sno;
C. SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG（Grade）＞=60;
D. SELECT Sno FROM SC GROUP BY Sno HAVING Grade ＞=60;
下列选项中哪一个是正确的空值查询条件的SQL表达（）
A. ＜ ＞NULL
B. !=NULL
C. IS NOT NULL
D. NOT IS NULL
检索选修了课程”C1”的学生中成绩最高的学生的学号，正确的SELECT语句为（）
A. SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞=ALL （SELECT Grade FROM SC WHERE Cno=’C1’）
B. SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN （SELECT Grade FROM SC WHERE Cno=’C1’）
C. SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞ ANY （SELECT Grade FROM SC WHERE Cno=’C1’）
D. SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE ＞= （SELECT Grade FROM SC WHERE Cno=’C1’）
微信支付 
支付宝支付