DBI202_-_PE_-_SU_2024_-_Block_10_2611.webp

1
2
3
4
5
6
7
8
708
845
872
871
707
844
843
870
7
7
7
7
7
7
7
7
324
324
324
288
5 of 5
288
288
252
252
Paper No: 1
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
+ 67%
Zoom
Close