You can omit the list of column names if you provide a value for each column in the table, in the order in which they appear
when you execute a query using SELECT *.

INSERT from SELECT

You can use SELECT within an INSERT statement to pull values from one or more tables. If the table you are inserting data
into has a large number of columns, you can also use WITH AUTO NAME to simplify the syntax. Using WITH AUTO NAME, you only
need to specify the column names in the SELECT statement, rather than in both the INSERT and the SELECT statements. The names
in the SELECT statement must be column references or aliased expressions.

A simplified version of the syntax for the INSERT statement using a select statement is: