Getting an error 1064 from a WITH but it works without it

"Incorrect syntax" when using a common table expression

WITH a AS
(
SELECT *
FROM student_table_name
WHERE student_id=6639352
ORDER BY modified DESC
)
SELECT * FROM a

Error Code: 1064 You have an error in your SQL syntax

It works without the

(
)
SELECT * FROM a

but when im running the inner query everything works! somehow the "with" command dont act like it should do..