[1 mark] Write a query to display ProductID, Name, TotalQuantity of the products having the highest TotalQuantity; where TotalQuantity is the total quantity in all locations of the corresponding product.
ProductID
Name
Total Quantity
379
Hex Nut 7
1911
1
Question 7:
Picture 6.1
[0.5 mark] Write a query to display, for each location, the information of the products having the highest Quantity. Display the information with the following attributes: LocationID,LocationName, ProductID, ProductName, Quantity; where ProductID, ProductName,
8 of 8
Paper No: 1
Quantity is the information of the products having the highest quantity in the given location.Display the result in ascending order of LocationName, then in descending order of ProductName with the products of the same location as follows:
LocationID
30
60
7
7
LocationName
ProductID
747
528
ProductName
Quantity
Debur and Polish
HL Mountain Frame Black, 38 148
Final Assembly
Seat Lug
Finished Goods Storage 708
Sport-100 Helmet, Black
Finished Goods Storage 872
Road Bottle Cage
729
324
324
1
2
3
4
Close
+ 100%
Zoom
