Zoom
attributes: 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.
ProductID
ProductName
Color Cost Price
LocationID
LocationName
Shelf Bin
Quantity
1
822
ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 10 ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 20
Frame Forming
N/A
0
115
2
822
Frame Welding
N/A
0
155
3
822
4
822
5
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
ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 50
Debur and Polish N/A
0
142
Paint
N/A
0
100
Subassembly
N/A 0
153
6
822
ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 60
Final Assembly N/A 0
131
7
833
ML Road Frame-W-Yellow, 40 Yellow 360,9428 594,83 NULL ML Road Frame-W-Yellow, 42 Yellow 360,9428 594,83 NULL
NULL
NULL NULL NULL
8
834
9
835
ML Road Frame-W-Yellow, 44 Yellow 360,9428 594,83 NULL
NULL
NULL NULL NULL
NULL
NULL NULL NULL
10 836
ML Road Frame-W-Yellow, 48 Yellow 360,9428 594,83 NULL LL Touring Frame Yellow, 62 Yellow 199,8519 333,42 NULL
NULL
NULL NULL NULL
11 886
NULL
NULL NULL NULL
12 899
13
900
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
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
+ 100%
Close