title: Create a table based on few columns of another table, but also add some additional columns
body: <p>I know I can do something like this:</p>
  
  <pre><code>CREATE TABLE new_table AS (
      SELECT field1, field2, field3
      FROM my_table
  )
  </code></pre>
  
  <p>I'm wondering how do I add more columns to this create table <code>SQL</code>, that are not from <code>my_table</code>, but instead ones that I would write my self and which would be unique to this <code>new_table</code> only.</p>
  
  <p>I know I could just make the table with the above <code>SQL</code> and then additionaly (after the command is completed) add the necessary columns, but am wondering if this all could be done in one command, maybe something like this (tried it like that, but didn't work):</p>
  
  <pre><code>CREATE TABLE new_table AS (
      (SELECT field1, field2, field3
      FROM my_table),
      additional_field1 INTEGER NOT NULL DEFAULT 1,
      additional_field2 VARCHAR(20) NOT NULL DEFAULT 1
  )
  </code></pre>