68 369
Assignments Done
98,7%
Successfully Done
In November 2018

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

Question #79376
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)
Expert's answer
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

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions