Answer to Question #79376 in Databases | SQL | Oracle | MS Access for Sherrie Douglas

Question

Write a SQL query for the following:

1. I need to know which of our sales reps don’t have any customers, all regions. (Hint: This is a different type of JOIN. Also, test for nulls and eliminate the managers.)

2. tell me which region managers are responsible for those sales reps who don’t have customers in all regions. Display the region ID, I can get the full name separately. (Hint: You’ll need to see the entire employee/customer list to provide this answer)

Answer 1

Dear Sherrie Douglas, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order