A top-level SELECT statement in an INSERT statement
Common table expressions are permitted within a top-level SELECT statement in an INSERT statement, but not within subqueries
within the INSERT statement.