sql server中查询视图

1、 在信息系学生的视图中找到年龄<20岁的学生

SELECT sname,
    sage
FROM is_student
WHERE sage<20

2、查询选修了1号课程的信息系的学生

SELECT is_student.sno,
    sname
FROM is_student,sc
WHERE is_student.sno = sc.sno
    AND sc.cno = '1'

3、在s_g视图中查询平均成绩在90分以上的学生学号和平均成绩

SELECT *
FROM s_g
WHERE gavg>85

4、如果没有视图，查询语句为

SELECT sno,
    avg(grade)
FROM sc
GROUP BY  sno
HAVING avg(grade)>85

5、用子查询进行查询

SELECT *
FROM 
    (SELECT sno,
    avg(grade)
    FROM sc
    GROUP BY  sno )as s_g (sno,gavg)
WHERE gavg > 85