WITH CTE_SC AS
(select Crs_Name, count(St_id)
from Course c, Stud_Course sc
where c.Crs_Id = sc.Crs_Id
group by Crs_Name)
with CTEE as
(select * from Student)
WITH CTE_SC AS
(select Crs_Name, count(St_id)
from Course c, Stud_Course sc
where c.Crs_Id = sc.Crs_Id
group by Crs_Name)
with CTEE as
(select * from Student)