Question 6:
mark] Write a query to display ProductID, Name, Total Quantity of the products having the highest TotalQuantity; where TotalQuantity is the total quantity in all locations of the corresponding product.
7 of 7 Paper No: 1
ProductID Name Total Quantity
1 379
Hex Nut 7 1911
Question 7:
Picture 6.1
[0.5 mark] Write a query to display, for each category, the subcategory having the maximum number of products. Display the result in the form of Category, SubcategoryName,NumberOfProducts where NumberOfProducts is the count of distinct products belonging to each product subcategory. For example, among different subcategories of the category
+ 67%
Zoom
Close
