Question: Provide working SQL DML statements for the following database schema and queries Provide working SQL DML statements for the following database schema and ueries EXERCISE
Provide working SQL DML statements for the following database schema and queries
Provide working SQL DML statements for the following database schema and ueries EXERCISE CUSTOMER (ID, Type, Firstname, Lastname, Address, City) INVENTORY(ID, ItemName, Type, MadeInStore, SupplierName, ORDERS (ID, Customer_FK, Item_FK, Quantity, DeliveryDate) 7. Show how many customers live in each city 8. Find customers that are restaurant owners (type) and live in 9. For each order, find which items have been ordered, how DailyAverageSold, Price) San Diego many of each, and ordered by delivery day - Show: item name and quantity 10. Find orders requesting "focaccia' - Show: order id, deliver date and item name 12
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
