'Yellow' color and having the Cost smaller than 400. Display the results with the following Kizspy. mefttributes: ProductID, ProductName, Color, Cost, Price, LocationID, LocationName, Shelf,Bin, Quantity. Note that LocationID, LocationName, Shelf, Bin, Quantity are NULL if we have no information about the product inventory of the corresponding product.
Zoom
ProductID ProductName Color Cost ML Road Frame-W-Yellow, 38 Yellow 360.9428 594.83 10
Price Location D LocationName
Shelf Bin
Quantity
822
Frame Forming NIA 0
115
822
ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 20
Frame Welding NA 0
155
822
ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 30 ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 40
Debur and Polish NA Paint
0
142
4
822
NIA O
100
5
822
ML Road Frame-W-Yellow, 38 Yellow 360,9428 594.83 50 ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 60
Subassembly
NIA 0
153
6 822
Final Assembly
N/A 0 131
7
833
ML, Road Frame-W-Yellow, 40 Yellow 360,9428 594,83 NULL
NULL
NULL NULL NULL
834
ML Road Frame-W-Yellow, 42 Yellow 360,9428 594,83 NULL
NULL
NULL NULL NULL
9
835
ML Road Frame-W-Yellow, 44 Yellow 360,9428 594,83 NULL ML Road Frame-W-Yellow, 48 Yellow 360.9428 594,83 NULL
NULL
NULL NULL NULL
10 836
NULL
NULL NULL NULL
11 886
LL Touring Frame Yellow, 62 Yellow 199.8519 333.42 NULL
NULL
NULL NULL NULL
12
899
LL Touring Frame Yellow, 44 Yellow 199,8519 333,42 NULL LL Touring Frame Yellow, 50 Yellow 199,8519 333,42 NULL
NULL
NULL NULL NULL
13 900
14 901
15 902
LL Touring Frame Yellow, 54
LL Touring Frame-Yellow, 58 Yellow 199,8519 333,42 NULL
Yellow 199,8519 333,42 NULL
NULL
NULL
NULL NULL NULL
NULL NULL NULL
NULL
NULL NULL NULL
Picture 4.1
Question 5:
[1 mark] Write a query to display SubcategoryID, SubCategoryName, Category,NumberOfProducts corresponding to each subcategory where NumberOfProducts is the count of distinct products of the corresponding subcategory; display the results in ascending
order of Category, then in descending order of NumberOfProducts for rows of the same
category and finally in ascending order of SubCategoryName of rows having the same
Category and NumberOfProducts as follows:
+ 67%
Close
