Saved Bookmarks
| 1. |
Consider the table ITEMSItem CodeNameCategoryUnit priceSales price0001PencilStationery5.0008.000002PenStationery8.0010.000003NotebookStationery10.0020.000004ChappalFootwear50.0070.000005AppleFruits60.0090.000006OrangeFruits40.0060.000007PenStationary10.009.00a) SELECT ITEMCODE, NAME FROM ITEMS WHERE CATEGORY = ‘Stationery’; b) SELECT * FROM ITEMS WHERE SALES_ PRICE < UNIT_PRICE; c) SELECT CATEGORY, COUNT(*) FROM ITEMS GROUP BY CATEGORY; |
||||||||||||||||||||||||||||||
|
Answer» a)
b)
c)
|
|||||||||||||||||||||||||||||||