Figure 11: Example SQL SELECT statement with an INSERT statement in the FROM clause

SELECT * FROM FINAL TABLE
  ( INSERT INTO bonus_candidates (empname, empserial, empsalary)
      INCLUDE inc_ytd_sales
      SELECT name, serial, salary, ytd_sales FROM sales_summary
        WHERE ytd_sales > 700000.00 )