Just found out I cannot use WITH

[John Coakley]

This is the problem I am working on:
Find the enrollment of each section (number of students enrolled) that was offered in Spring 2010.

This is the query that I created, but it flags the WITH statement, is there an alternative to this to get working?

USE JACLLC;
SET SQL_SAFE_UPDATES = 0;
WITH sec_enrollment AS (
SELECT course_id, count(ID) as enrollment
FROM section NATURAL JOIN takes
WHERE semester = 'Spring'
AND year = 2010
GROUP BY course_id,sec_id
SELECT course_id, sec_id
FROM sec_enrollment
WHERE enrollment = (SELECT MAX(enrollment) from sec_enrollment