Question: Provide working SQL DML statements for the following database schema and queries Provide working SQL DML statements for the following database schema and queries EXERCISE
Provide working SQL DML statements for the following database schema and queries
Provide working SQL DML statements for the following database schema and queries EXERCISE CUSTOMER (ID, Type, Firstname, Lastname, Address, City) INVENTORY(ID, ItemName, Type, MadeInStore, SupplierName, ORDERS(ID, Customer_FK, Item_FK, Quantity, DeliveryDate) 3. Update values for Type in table CUSTOMER to ailyAverageSold, Price) Value "Business" for customers of type "Restaurant'" 4. Update values for Type in table CUSTOMER to Value "Corporate" for customers of type "Office" Update values for Type in table CUSTOMER to Value "Southern" for customers of type "Restaurant" living in "San Diego Update values for Type in table CUSTOMER to Value "Fidelity" for customers that have placed at least one order 5. 1 6
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
