8.25. INSERT

    If the list of column names is specified, they must exactly match the listof columns produced by the query. Each column in the table not present in thecolumn list will be filled with a value. Otherwise, if the list ofcolumns is not specified, the columns produced by the query must exactly matchthe columns in the table being inserted into.

    1. INSERT INTO orders

    Insert a single row into the cities table:

    1. INSERT INTO cities VALUES (2, 'San Jose'), (3, 'Oakland');

    Insert a single row into the nation table with the specified column list:

    1. INSERT INTO nation (nationkey, name, regionkey)

    VALUES