Create a Table From a SQL-Derived Table

Data obtained from a SQL-derived table can be inserted into a new table.

select pubdate into pub_dates
   from (select pubdate from titles) dt_e
            where pubdate = "450128 12:30:1PM"

Data from the SQL-derived table dt_e is inserted into the new table pub_dates.