title: Getting an Odd Syntax Error With SQL Query
body: <p>I'm writing what should be a fairly straightforward SQL query for a modification of the IMDB database; it's supposed to return a list of all films that are categorized as BOTH horror and comedy, which I've done by creating a list of horror, a list of comedy, and then deleting everything from one that's not in the other. The query is as follows:</p>
  
  <pre><code>WITH
  
  table_left AS (SELECT primary_names.name AS name, year, genre, title_id
  FROM titles NATURAL JOIN primary_names NATURAL JOIN title_genres WHERE genre = 'Horror'),
  
  table_right AS (SELECT primary_names.name AS name, year, genre, title_id
  FROM titles NATURAL JOIN primary_names NATURAL JOIN title_genres WHERE genre = 'Comedy')
  
  DELETE FROM table_right WHERE (title_id NOT IN (SELECT table_left.title_id))
  
  SELECT name, year FROM table_right;
  </code></pre>
  
  <p>However, this generates an "ERROR: syntax error at or near 'SELECT'" on the last line of the query. I'm fairly new to SQL, but have gone over the syntax multiple times and checked some guides and I just can't understand what's going wrong. There shouldn't be a comma after the DELETE FROM statement, I don't think I've got a comma in any inappropriate places...it may be staring me in the face, but I'm at a loss, and would love to hear any suggestions.</p>