Search for question
Question

For each employee with a commission less than 0.04, compute the number of orders taken. The result should include the employee number, employee last name, employee commission rate, and the total number of orders taken by that employee. Assume each distinct OrdNo in the OrderTbl counts as one distinct order. Each employee should be displayed only once; for example, if employee Mickey Mouse took five orders, there should be one line displaying his name, not five.