title: Presto create table with 'with' queries
body: <p>typically to create a table in Presto (from existing db tables), I do:</p>
  
  <pre><code>create table abc as (
  select...
  )
  </code></pre>
  
  <p>But to make my code simple, I've broken out subqueries like this:</p>
  
  <pre><code>with sub1 as (
  select...
  ),
  
  sub2 as (
  select...
  ),
  
  sub3 as (
  select...
  )
  
  select
  from sub1 join sub2 on ...
            join sub3 on ...
  </code></pre>
  
  <p>Where do I put the create table statement here? The actual query is more complex than the above so I am trying to avoid having to put the subqueries within the main query.</p>