USE XK G ALTER VIEW V CouByDep WITH ENCRYPTION AS SELECT DepartName, COUNT(*) Amount FROM Course, Department WhERE Course. DepartNo=Department. DepartNo GROUP BY DepartNameUSE XK GO ALTER VIEW V_CouByDep WITH ENCRYPTION AS SELECT DepartName,COUNT(*) Amount FROM Course, Department WHERE Course.DepartNo=Department.DepartNo GROUP BY DepartName