Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT Employee.EmpNo, EmpLastName, COUNT(*) AS NumOrders
- FROM OrderTbl, Employee
- WHERE OrdDate BETWEEN #1/1/2004# AND #1/31/2004#
- AND Employee.EmpNo = Employee.EmpNo
- AND EmpCommRate < 0.04
- GROUP BY Employee.EmpNo, EmpLastName
Add Comment
Please, Sign In to add comment