Write a query to show the number of orders for each shipper

Assignment Help Computer Engineering

Reference no: EM132117892

For the questions below, use the W3Schools customer orders database. You need to submit thoroughly tested SQL statements. For your convenience and reference, relevant data model is attached as a PDF document with the assignment in the Blackboard. Name of this document is "Relationship diagram for W3schools order.pdf."

1) Write a query to show Customers' Country wise sales totals. Your query should show Customers' Country name and the total sale value for that Country.

2) Write a query to show Product wise sales totals. Your query should Product name and the total sale value for that Product.

3) Write a query to show the number of orders for each shipper. Your query should show shipper name and the count of orders with the shipper.

4) Write a query to show number of products in each product category. Your query should show Category name and number of products in that category.

5) Write a query that shows Customers' country wise customer count, and order count. Your query should show country name, total number of customers from that country, and total number of orders from the customers of that country.

6) Write a query that shows the number of products supplied by each Supplier. Your query should show Country name, supplier name and the count of products supplied by that supplier. Note: Sale Price = Orderdetails.Quantity * Products.price (see an example in the class slides deck)

Reference no: EM132117892

Questions Cloud

Plot the six histograms in a single graphics window : Remember that all figures have exactly the same underlying distribution. Plot the six histograms in a single graphics window and label them accordingly.

Approximate real rate of interest : If Treasury bills are currently paying 3.9 percent and the inflation rate is 2.1 percent, what is the approximate real rate of interest? The exact real rate?

What is the yield to maturity for bond : The bond has 13 years left to maturity. The bond is selling for $1018. What is the yield to maturity for this bond?

What would the level of per capita income : Some economists have argued that growth rates are mismeasured. For example, it may be difficult to compare per capita income today with per capita income.

Write a query to show the number of orders for each shipper : Write a query to show number of products in each product category. Your query should show Category name and number of products in that category.

What is the purpose of macroeconomic models : What is the purpose of macroeconomic models? How can a model of ice cream production be used to explain 50-fold income differences across countries?

Calculate the return and standard deviation : Calculate the return and standard deviation for the following stock, in an economy with five possible states.

By how much would wages rise : Can you attach a number to your explanation? In the model, by how much would wages rise if a third of the population died from disease?

What does olson mean by the statement : Institutions and economic performance: Read the article on institutions by Mancur Olson, cited in footnote 10. (You may be able to find it on the Web by typing)

User Account

All Pages