Guest User

Untitled

a guest
Dec 12th, 2018
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.25 KB | None | 0 0
  1. SELECT Employee.EmpNo, EmpLastName, COUNT(*) AS NumOrders
  2. FROM OrderTbl, Employee
  3. WHERE OrdDate BETWEEN #1/1/2004# AND #1/31/2004#
  4. AND Employee.EmpNo = Employee.EmpNo
  5. AND EmpCommRate < 0.04
  6. GROUP BY Employee.EmpNo, EmpLastName
Add Comment
Please, Sign In to add comment