why i got Parentheses error message while using CTEs "Msg 102, Level 15, State 1, Line 5 Incorrect syntax near ')'."

Viewed 21
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)
0 Answers
Related