title: Getting a Syntax Error when Trying to Create a CTE in MySQL
body: <p>Here's the code:</p>
  <pre><code>WITH sub_query AS (Select imdp_title_id FROM movie_ratings) 
  </code></pre>
  <p>Here's the output:</p>
  <pre><code>Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
  </code></pre>
  <p>MySQL version : '8.0.26'</p>
  <p>Software Used : MySQL Workbench 8.0</p>
  <p>Thanks in advance.</p>