createcourceview.sql

非常好的源码

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