(Solved) : Consider Following Relational Database Schema Customer Cust Ld Cust Name City Order Order Q30748776 . . .
![]()
Consider the following relational database schema; Customer(Cust-ld,Cust-name,City) Order (Order-Number, Order-Date, Customer-ld, Order-amount) Order-ltem (Order-Number, Item-Number, Quantity) Item (Item-Number, Unit, Price) Shipment (Order-Number, warehouse-Number, Ship-Date) Warehouse (Warrehouse-Number, City) Write SQL Queries for the following: (1) list the orders that were not shipped within 30 days of ordering (2) List Customer-name, numberof orders, average order amountfor each customerwho has placed atleast one order (3) List the order-number, order-date, warehouse number of all orders of customer”Dinesh” jFind al the Customednrr lst 2 months (5) Find all the orders which have been shipped from any warehouse the company has in “Chandigarh” Show transcribed image text
Expert Answer
Answer to Consider Following Relational Database Schema Customer Cust Ld Cust Name City Order Order Q30748776 . . .
Related