Consider the following items relation. Supplier_idItem_id Quantity Price Item_name Cable 123 111 5..

Consider the following items relation. Supplier_idItem_id Quantity Price Item_name Cable 123 111 5 12.50 123 122 Monitor 3 60.00 345 111 Cable 3 12.50 345 133 Printer 6 45.00 567 133 6 45.00 Printer Scanner 789 255 2 35.00 1. Write an SQL statement to create the items table. 4 marks Write an SQL statement to add the following item information: (123, 255, Scanner). 2 mark Write an SQL statement to find all suppliers id who supplies Printer item, and order them alphabetically. 2 marks 4. Write an SQL statement to delete all items with a price greater than 35. 2 mark

Order your essay today and save 15% with the discount code: VACCINE

Order a unique copy of this paper

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
Top Academic Writers Ready to Help
with Your Research Proposal