例4、创建一个名为 V CouBy Dep,使其能显示各系 部开设选修课程的门数据 USE XK GO CREATE VIEW V CouByDep AS SELECT DepartNo, COUNT (*)Amount FROM Course GROUP BY DepartNo例4、创建一个名为V_CouByDep，使其能显示各系 部开设选修课程的门数据。 USE XK GO CREATE VIEW V_CouByDep AS SELECT DepartNo,COUNT(*) Amount FROM Course GROUP BY DepartNo