20 322
21 329
Chainring
Road End Caps
0.00
475
0.00 467
22 330
23 828
Touring End Caps
0.00 457
24
2
HL Road Rear Wheel
Rasring Dall
35...
432
427
Picture 3.1
Question 4:
[1 mark] Write a query to display the product inventory information for all products having the 'Yellow' color and having the Cost smaller than 400. Display the results with the following 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.
6 of 6
Paper No: 1
ProductID ProductName
Color Cost
Price
LocationID
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
2
822
LocationName
Frame Forming Frame Welding N/A 0
Shelf Bin
Quantity
N/A
0
115
155
3
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 N/A 0 Paint N/A
142
4
822
5 822
ML Road Frame-W-Yellow, 38 Yellow 360,9428 594,83 50
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
NULL NULL NULL NULL
8 834
ML Road Frame-W-Yellow, 42 Yellow 360,9428 594,83 NULL
NULL
NULL NULL NULL
Zoom
+ 100%
Close
