title: Amazon Redshift: Errors after "WHERE DATE = ..."
body: <p>I am trying to create a temp table in AWS Redshift that takes two dates as a minimum column and a maximum column from a calendar table. This is the code I have:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TEMP TABLE DATE_RANGE AS
  (
    (SELECT *
    FROM CALENDAR
    WHERE DATE = '2016-12-14') AS MIN_DATE,
    (SELECT *
    FROM CALENDAR
    WHERE DATE = '2022-01-08') AS MAX_DATE
     
  ) 
  </code></pre>
  <p>However I keep getting syntax errors after &quot;WHERE DATE =...&quot; and I'm not sure where to go Anyone have any ideas?</p>