createview ST_CO_SR asselect a.stno, a.stname, c.cno, cname, grade
from student a
innerjoin score b on a.stno = b.stno
innerjoin course c on c.cno = b.cno;-- 输出视图结果select*from ST_CO_SR;
createview ST_computer asselect stname,
cname,
grade
from student a
innerjoin score b on a.stno = b.stno
innerjoin course c on c.cno = b.cno
where speciality ='计算机';-- 输出视图结果select*from ST_computer;
输出
创建视图 ST_AV,它包含学生姓名、平均分等列,并输出该视图的所有记录。
createview ST_AV asselect stname,avg(grade)as"avgScore"from student a
innerjoin
score b on a.stno = b.stno
groupby stname;-- 输出视图结果select*from ST_AV;