h query in this relational database (represented by relational diagram) will provide you with the list of the 3 most transported products by shipper DHL in January 2020?
h query in this relational database (represented by relational diagram) will provide you with the list of the 3 most transported products by shipper DHL in January 2020?
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
The snips of the question are attached. As the question was long therefore added 1 and 1 continued.
Need to find the correct answer for this Northwind
Transcribed Image Text:Which query in this relational database (represented by relational diagram) will provide you with the list of the 3 most transported products by shipper DHL in January 2020?
Employees
* EmployeelD
EmployeeTerritories
* EmployeelD
CustomerDemographics
9 CustomerTypelD
LastName
* TerritorylD
CustomerDesc
FirstName
Title
TitleOfCourtesy
Territories
BirthDate
CustomerCustomerDemo
* TeritoryiD
HireDate
9 CustomeriD
od 9 CustomerTypelD
TerritoryDescription
Address
lco
RegionID
City
Region
PostalCode
Region
* RegioniD
Country
Customers
HomePhone
* CustomeriD
Extension
RegionDescription
CompanyName
Photo
ContactName
Notes
ContactTitle
Lodi
ReportaTo
Address
PhotoPath
City
Region
PostalCode
Country
Phone
Order Details
Fax
7 OrderlD
Products
* ProductiD
ad 7 ProductiD
UnitPrice
ProductName
Quantity
SupplieriD
Discount
CategoryID
Quantity PerUnit
Orders
UnitPrice
O ? OrderiD
UnitsinStock
CustomeriD
UnitsOnOrder
EmployeelD
Categories
* CategoryID
Reorderlevel
OrderDate
Discontinued
RequiredDate
CategoryName
ShippedDate
Description
ShipVia
Picture
Freight
ShipName
Suppliers
* SupplieriD
ShipAddress
ShipCity
CompanyName
ShipRegion
ContactName
ShipPostalCode
ContactTitle
Shippers
* ShipperiD
ShipCountry
Address
City
CompanyName
Region
Phone
PostalCode
Country
![Companyflama
ShipRegion
ComactName
ShipPortalCode
Cortacttte
ShipCounty
Shippers
1 shppera
Addiess
City
ComparyName
Region
Phone
PostaiCode
Counay
Phane
Fax
HamaPage
Select one:
a.
SELECT TOP(3) p.ProductID, p.ProductName, COUNT(od.Quantity)
FROM Products p
FULL JOIN [Order Details] od ON p.ProductiD = od.ProductID
FULL JOIN Orders o ON od.OrderlD = 0.OrderlD
FULL JOIN Shippers s ON o.ShipVia = 5.ShipperID
WHERE s.CompanyName = "DHL' AND MONTH(0.ShippedDate) = 1 AND YEAR(O.ShippedDate) = 2020
GROUP BY p.ProductiD, p.ProductName
ORDER BY COUNT(od.Quantity) DESC
b.
SELECT TOP(3) p.ProductName, COUNT(od.Quantity)
FROM Productsp
INNER JOIN [Order Details) od ON p.ProductID = od.ProductID
INNER JOIN Orders o ON od.OrderlD = 0.OrderlD
WHERE o.ShipVia = 'DHL' AND o.ShippedDate > "01-01-2020 AND o.ShippedDate < '31-01-2020
GROUP BY p.ProductiD, o.ShipVia
ORDER BY COUNT(od.Quantity) DESC
C.
SELECT TOP(3) p.ProductiD, p.ProductName, SUM(od.Quantity)
FROM Products p
INNER JOIN [Order Details) od ON p.ProductID = od.ProductiD
INNER JOIN Orders o ON od.OrderlD = 0.0rderiD
INNER JOIN Shippers s ON o.ShipVia = 5.ShipperiD
WHERE s.CompanyName = "DHL' AND MONTH(0.ShippedDate) = 1 AND YEAR(O.ShippedDate) = 2020
GROUP BY p.ProductID, p.ProductName
ORDER BY SUM(od.Quantity) DESC
d.
SELECT TOP(3) p.ProductID, p.ProductName, COUNT(od.Quantity)
FROM Products p
INNER JOIN [Order Details) od ON p.ProductiD = od.ProductID
INNER JOIN Orders o ON od.OrderiD = o.OrderiD
INNER JOIN Shippers s ON o.ShipVia = s.ShipperiD
WHERE s.CompanyName = "DHL' AND o.ShippedDate > '01-01-2020 AND o.ShippedDate < '31-01-2020
GROUP BY s.ShipperiD, s.CompanyName
ORDER BY COUNT (od.Quantity) DESC
e.
SELECT TOP(3) p.ProductiD, p.ProductName, SUM(od.Quantity)
FROM Productsp
LEFT JOIN [Order Details] od ON p.ProductID = od.ProductID
LEFT JOIN Orders o ON od.OrderiD = 0.OrderlD
LEFT JOIN Shippers s ON o.ShipVia = s.ShipperiD
WHERE s.CompanyName LIKE 'DHL" AND MONTH(0.ShippedDate) = 1 AND YEAR(o.ShippedDate) = 2020
GROUP BY od.ProductID, o.ShipAddress
ORDER BY SUM(od.Quantity) ASC](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F26396183-6090-4b73-bd67-7f89fc8b531f%2F3a6f4cac-5f8e-4391-82ec-1ff8c3dbb099%2Fldyxwda_processed.png&w=3840&q=75)
Transcribed Image Text:Companyflama
ShipRegion
ComactName
ShipPortalCode
Cortacttte
ShipCounty
Shippers
1 shppera
Addiess
City
ComparyName
Region
Phone
PostaiCode
Counay
Phane
Fax
HamaPage
Select one:
a.
SELECT TOP(3) p.ProductID, p.ProductName, COUNT(od.Quantity)
FROM Products p
FULL JOIN [Order Details] od ON p.ProductiD = od.ProductID
FULL JOIN Orders o ON od.OrderlD = 0.OrderlD
FULL JOIN Shippers s ON o.ShipVia = 5.ShipperID
WHERE s.CompanyName = "DHL' AND MONTH(0.ShippedDate) = 1 AND YEAR(O.ShippedDate) = 2020
GROUP BY p.ProductiD, p.ProductName
ORDER BY COUNT(od.Quantity) DESC
b.
SELECT TOP(3) p.ProductName, COUNT(od.Quantity)
FROM Productsp
INNER JOIN [Order Details) od ON p.ProductID = od.ProductID
INNER JOIN Orders o ON od.OrderlD = 0.OrderlD
WHERE o.ShipVia = 'DHL' AND o.ShippedDate > "01-01-2020 AND o.ShippedDate < '31-01-2020
GROUP BY p.ProductiD, o.ShipVia
ORDER BY COUNT(od.Quantity) DESC
C.
SELECT TOP(3) p.ProductiD, p.ProductName, SUM(od.Quantity)
FROM Products p
INNER JOIN [Order Details) od ON p.ProductID = od.ProductiD
INNER JOIN Orders o ON od.OrderlD = 0.0rderiD
INNER JOIN Shippers s ON o.ShipVia = 5.ShipperiD
WHERE s.CompanyName = "DHL' AND MONTH(0.ShippedDate) = 1 AND YEAR(O.ShippedDate) = 2020
GROUP BY p.ProductID, p.ProductName
ORDER BY SUM(od.Quantity) DESC
d.
SELECT TOP(3) p.ProductID, p.ProductName, COUNT(od.Quantity)
FROM Products p
INNER JOIN [Order Details) od ON p.ProductiD = od.ProductID
INNER JOIN Orders o ON od.OrderiD = o.OrderiD
INNER JOIN Shippers s ON o.ShipVia = s.ShipperiD
WHERE s.CompanyName = "DHL' AND o.ShippedDate > '01-01-2020 AND o.ShippedDate < '31-01-2020
GROUP BY s.ShipperiD, s.CompanyName
ORDER BY COUNT (od.Quantity) DESC
e.
SELECT TOP(3) p.ProductiD, p.ProductName, SUM(od.Quantity)
FROM Productsp
LEFT JOIN [Order Details] od ON p.ProductID = od.ProductID
LEFT JOIN Orders o ON od.OrderiD = 0.OrderlD
LEFT JOIN Shippers s ON o.ShipVia = s.ShipperiD
WHERE s.CompanyName LIKE 'DHL" AND MONTH(0.ShippedDate) = 1 AND YEAR(o.ShippedDate) = 2020
GROUP BY od.ProductID, o.ShipAddress
ORDER BY SUM(od.Quantity) ASC
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY