View the step-by-step solution to:

Hi there. Perform SQL query against the Northwind database that lists the dollar amount each employee shipped to a particular country.

Hi there. Please help with pivot (corsstab) query (#2 below)


DONE -- 1. Perform SQL query against the Northwind database that lists the dollar amount each employee shipped to a particular country. Identify each employee by employee ID. The output of your result should contain the following header columns: Employee ID, Ship Country, and Amount. A sample output would look like the following:

Write SQL query to list the dollar amount each employee shipped to a particular country.

SELECT

Employee_ID AS EmployeeID,

Ship_Country AS ShipCountry,

Freight AS Amount

FROM orders

;


PLEASE HELP HERE...

 

2. Building on the previous SQL query, Perform another query using a pivot that lists the total dollar amount shipped to each country by each employee. The output of your query result should contain the following header columns: Employee ID, Austria, Finland, Italy, France, Germany, Brazil, Belgium, and Switzerland. The output should be: 

MIS541 mod 2 pic2.png

MIS541 mod 2 pic2.png

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question