Write a query to list the orders shipped by speedy express

Assignment Help Computer Engineering

Reference no: EM132213164

Question :

A) Write a query to show the list of number of orders for customers located in each country. Your query results should show Country name, and number of orders from the customers of that country. Partial credit (25% of the credit) will be given if you correctly identify the tables to be joined.

B) Write a query to list the orders shipped by "Speedy Express". Your query should show the Order Date and Order ID. The results should appear in the sort order of Order Date.

C) Which of the three shippers "Speedy Express", "United Package", or "Federal Shipping" shipped the most number of orders? Please explain how you arrived at your response?

Is it correct these solutions below?

SELECT Country,

count(Country) as NumberOfOrdersfromtheCustomers

FROM Customers

GROUP BY Country

B) I need help for the solution here

SELECT

ShipperID,

ShipperName,

count(ShipperID) as Orders

FROM

(SELECT

o.ShipperID,

s.ShipperName

FROM Orders as o

JOIN Shippers as s

ON o.ShipperID = s.ShipperID)

GROUP BY ShipperID;

Reference no: EM132213164

Questions Cloud

Variables of type string : Suppose s1 and s2 are variables of type String, and both have been properly initialized with non-empty values.

Flow through various stages of business cycle : According to your textbook, a nation's economy tends to flow through various stages of a business cycle: prosperity, recession, depression, and recovery.

Evaluating the performance of managers : Starlight Industries computes variances as a basis for evaluating the performance of managers responsible for controlling costs. For several months.

What is the difference between socs and nocs : What is the difference between SOCs and NOCs? Please explain.

Write a query to list the orders shipped by speedy express : Write a query to list the orders shipped by "Speedy Express". Your query should show the Order Date and Order ID.

When think of a particular audience for future speeches : When think of a particular audience for future speeches, how can determine what their positions are about topic?

Write a python program that implements a game : Write a python program that implements a game in which the user first enters the distance to a target.

Attributes are in terms of speaking : Pollan is a known speaker and there is a reason are drawn to him. What would say some of his attributes are in terms of speaking?

About introducing them to US business culture : What would be the most important things for them to learn as a result of the process? How would you go about introducing them to U.S. business culture?

User Account

All Pages