title: How do I create a new table with one column from another table in SQL?
body: <p>I am new to SQL and am having trouble getting the syntax for this particular process right. I just want to take a column of names out of a pre-existing table and create a new one column table with that column, then select that table. </p>
  
  <p>I'm getting an error that says newTable already exists. </p>
  
  <p>Here's my code right now:</p>
  
  <pre><code>BEGIN
      CREATE TABLE newTable (name varchar(255));
      INSERT INTO newTable SELECT name FROM oldTable;
      SELECT * FROM newTable;
  END
  </code></pre>