Database Systems

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, DailyAverageSold, Price) ORDERS (D, customer-FI, Item-FK, Quantity, DeliveryDate) 16. Find the total amount due for each order, where the total is at least $70 Show: order id, lastname, and total-amount Hint: variation of previous query 17. Find the total amount due for each order placed by a customer that is a restaurant owner, total is at least $70 and the number of different item types (not the units) is less than 3 - Show: order id, lastname, and total-amount, number of different types of items in the order Hint: variation of previous query