Creating a table from a SQL derived table

Data obtained from a SQL derived table can then be inserted into a new table, as in the following example.

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

Here data from the SQL derived table dt_e is inserted into the new table pub_dates.