Question: Provide working SQL DML statements for the following database schema and queries EXERCISE CUSTOMER , Type, Firstname, Lastname, Address, City) INVENTORY (ID, ItemName, Type, MadelnStore,

 Provide working SQL DML statements for the following database schema and

Provide working SQL DML statements for the following database schema and queries EXERCISE CUSTOMER , Type, Firstname, Lastname, Address, City) INVENTORY (ID, ItemName, Type, MadelnStore, SupplierName DailyAverageSold, Price) ORDERS (ID, Customer FK, Item FK, Quantity, DeliveryDate) 11. Find orders requesting 10 or more units of a product . Show: order id, deliver date, item name, quantity Find what products and how many units of each product 12. customers ordered in each order . Show: Lastname, firstname, item name, and quantity For each item in each order, find the item partial amount . Show: order id, lastname, quantity, price and partial-amountt . Hint: Partia!Amount = Quantity * Price 13

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!