Problem04 list the employee number the employee name

This preview shows page 1 - 2 out of 2 pages.

-- Problem_04: List the employee number, the employee name (first and last), thecommission rate, -- the supervising employee name (first and last), and the commission rate of the supervisor.-- Problem_05: List the employee number, the employee name (first and last), andtotal amount of commissions on orders -- taken in January 2030. The amount of a commission is the sum of the dollar amount of products ordered times the -- commission rate of the employee.-- Problem_06: Using join operator style, list the product name and the price ofall products -- ordered by Beth Taylor in January 2030. Remove duplicate rows from the result.-- Problem_07: For Colorado customers, compute the number of orders placed in January 2030 in which the orders contain -- products made by Connex. The result should include the customer number, last name, and the number of orders placed -- in January 2030.-- Problem_08: For each employee with a commission rate of less than 0.04, compute the number of orders taken in January 2030.

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture