24
2
Dosing Dall
Picture 3.1
Question 4:
000 427
[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 LocationName
Shelf Bin
Quantity
1
822
2
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 Frame Welding N/A
115
0
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
142
4
822
Paint
N/A
0
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 Final Assembly
N/A 0
153
6 822
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
و
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
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 Yellow 199,8519 333,42 NULL
LL Touring Frame-Yellow, 58
NULL
NULL NULL NULL
NULL
NULL NULL NULL
Yellow 199,8519 333,42 NULL
NULL
NULL NULL NULL
Picture 4.1
Zoom
+ 100%
Close
