Typing
oceanqueen
DatabaseActivity2-Queries.docxDatabase Activity - QUERIES
Retrieve the database called Inventory_yourname.
Item Table
Perform the following queries using the product table:
2. List the item id, description and vendor code, selling price for all products supplied by vendor code OH. Name query OHprod. (2 marks)
3. List the item id, selling price for all products with a selling price above 60. Name query Above60. (2 marks)
4. List the item id, selling price, and cost for all products with a cost below 50. Name query Below50. (2 marks)
5. Item code, description and available of all products that have below 20 available. Name query Low. (2 marks)
