title: Simple SQL Table Insert
body: <p>I'm looking to take the data from the query below (all employees in Seattle) and insert it into a new, blank table with identical columns as my select statement.</p>
  
  <pre><code>select e.employee_id, e.first_name, e.last_name, e.email, e.phone_number, e.hire_date, e.job_id,       e.salary, e.commission_pct, e.manager_id, e.department_id
  from employees e
  join departments d
  on e.department_id = d.department_id
  join jobs j
  on e.job_id = j.job_id
  join locations l
  on d.location_id = l.location_id
  where l.city = 'Seattle';
  </code></pre>
  
  <p>Any idea how to do this?</p>