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, DailyAverageSold, Price) ORDERS (ID, Customer_FK, Item FK, Quantity, DeliveryDate) 10. Show the lastname of customers that either Have placed at least one order totaling more than $70 . Or, live in "Bonita" 11. Show the item names in orders totaling more than $70 12. Find customers that have placed at least one orde:r Do not use JOIN 13. Find customers that have never placed an order Do not use JOIN
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
