And this is NOT going to get you what you think:
5.Display the customer name, employee name, and employee ID for all orders that were handled by the Sales Representatives.
this is my answer
SELECT a.ContactName, b.FirstName, b.EmployeeID
FROM Customers AS a, Employees AS b
WHERE Title like'*Seles Representative*';
Look around the site a little, especially under the "newbies" section (OR read BOL - hint - "Select") for simple select statements. Plenty of samples the should lead you in the right direction for most of your questions - or pay attention more in class??
-- You can't be late until you show up.