Correlated subqueries
ricky martin
06 de Marzo del 2005
Use the Orders table in the Northwind database to write a correlated subquery that displays the highest EmployeeID associated with each ShipCountry. This means your correlated subquery should display each country name and the employee with the highest EmployeeID. The results should be ordered by country name.
Deliverable Details
After you've tested your code and fixed any errors, submit the code in a .sql file named U5_corsubq_[Last Name]. Also submit a Word document named U5_corsubq_text_[Last Name] that includes a screen shot of the results of your correlated subquery. In the document also outline other methods by which this task could be accomplished and why or why not they should be used over the correlated subquery method.
Deliverable Details
After you've tested your code and fixed any errors, submit the code in a .sql file named U5_corsubq_[Last Name]. Also submit a Word document named U5_corsubq_text_[Last Name] that includes a screen shot of the results of your correlated subquery. In the document also outline other methods by which this task could be accomplished and why or why not they should be used over the correlated subquery method.