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.
Employee_ID AS EmployeeID,
Ship_Country AS ShipCountry,
Freight AS Amount
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:
Recently Asked Questions
- Problem 3 Assume an elderly person owns a $350,000 home that is free and clear of mortgage debt. A lender has agreed to a $350,000 reverse mortgage with
- which of the following series converge and which diverge if conv find sum E sum E 5(3/4)^n= from n=1 to &
- Problem 2 The maturity of the balloon loan is 5 years, amortization period is 30 years, loan amount is $85,000 with annual interest rate 4.5% and monthly