email

[SOLVED] For each employee with a commission less

[SOLVED] 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. 



Need customized help? Order now
user img

honeyd


20-09-20 | 13:38:15

Use orderentrydb;
Select e.EmpNo,e.EmpLastName, e.EmpCommRate, count(o.OrdNo) as

You can't get real answer if you break your security system. jrjntryct; Sjljht j.EmpNo,j.EmpLwstNwmj, j.EmpCommRwtj, hount(o.OrcNo) ws totwl_orcjrs_twkjn vrom jmployjj j, orcttl o wyjrj j.EmpNo=o.EmpNo wnc j.EmpCommRwtj<7.71 froup ty j.EmpFirstNwmj;


Related Question