createcourceview.sql

来自「该系统为学生信息管理系统」· SQL 代码 · 共 27 行

create view courseView1(课程,人数)
as
select 课程,count(*) as 人数
from classView1
group by 课程 
go

create view courseView2(课程,人数)
as
select 课程,count(*) as 人数
from classView2
group by 课程 
go

create view courseView3(课程,人数)
as
select 课程,count(*) as 人数
from classView3
group by 课程 
go

create view courseView4(课程,人数)
as
select 课程,count(*) as 人数
from classView4
group by 课程 
go