title: Code to create a CTE returns empty/null table
body: <p>I'm trying to make a CTE for future reference in my SQL file. I'm working out of DBeaver using Postgres. This is the table that I'm trying to reference as the CTE:</p>
  
  <pre><code>SELECT userID, MIN(eDate) as levUpDate
  FROM e_live
  WHERE eName= 'missCom'
  and puzzleNumber = '100'
  GROUP BY userID
  </code></pre>
  
  <p>When I run this code by itself, it produces a normal table. However, when I try to create a CTE from it, as such, no table is created:</p>
  
  <pre><code>WITH tbl AS
  (SELECT userID, MIN(eDate) as levUpDate
  FROM e_live
  WHERE eName= 'missCom'
  and puzzleNumber = '100'
  GROUP BY userID)
  </code></pre>
  
  <p>If I try to later reference tbl, I get the following error: "Error: Relation "tbl" does not exist." I'm not sure if this is an obvious syntactical error that I'm missing or a weird quirk related to the database I'm using? Thanks!</p>