• put a semicolon in front of the with on the CTE