Question: 1- Create view for all customers with their orders 2- Create a query to display the orders that were not shipped within 30 days of

1- Create view for all customers with their orders 2- Create a query to display the orders that were not shipped within 30 days of ordering 3- Delete all orders for customer named "Sara". 4-

1- Create view for all customers with their orders

2- Create a query to display the orders that were not shipped within 30 days of ordering

3- Delete all orders for customer named "Sara".

4- List all customer names whose orders were shipped from a warehouse in the same city as they live in.

USE ORACLE SQL THANK YOU!

Customer custNo 11 22 33 cname Sara Fatma Omar Ali City Doha Doha Khor Shimal Khor 44 55 Hassan Odate Orders Order No 21 22 03-04-02 09-03-04 CustNo Ord_amt 11 10000 22 11000 33 14000 44 16000 55 20000 23 23-01-01 11-08-08 24 25 06-10-10 Item ItemNo Unit Price 1 1100 2 1200 3 1300 4 1400 5 1500 Qty 20 order_Item Order No 21 25 22 24 23 un 30 Item No 1 5 2 4 3 40 10 60 shipment Order No WarehouseNo Ship_date 21 W1 11-Jan-02 25 W2 24-Feb-10 22 W3 13-Jun-05 24 W4 16-Sep-09 23 W5 28-Apr-03 Warehouse WarehouseNo City W1 Najma W2 Khor W3 Doha W4 Muntza W5 Rayaan

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!

Using SQL 1. Cite the following lobes 2 the ble bride CUTE! Gust este CATE Sana Oly Data ca Number 22 22 un | Vandu Merchand 6 ty nap Her Ha Number 3 nike Orders Order Ode 21 0302 09-03-01 23 00 01...

3. Create sequence for customer number start with 1 and end with 999 . 4. Create view for all customers with their orders. 5. Create a query to display the orderNo and Ship_date for all orders...

3. Create sequence for customer number start with 1 and end with 999. 4. Create view for all customers with their orders. 7. Create a query to display the cname,No_of_orders, Avg_order_amt, where the...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

create a general journal, general ledger, unadjusted trial balance, adjusted trial balance, income statement, and shareholder's equity statement Productions Legal Pad Nume Name 1110 Cash 1120...

Summary: Please analyze the case Dakota Office Products by identifying the activities, cost drivers and then analyzing customers A and B profitability. Assess Dakota's current use of a single...

Required information [The following information applies to the questions displayed below) Background: Baer Belly Bikinis Inc. (BBB) is a small business located in Santa Monica, California. It sells...

Find using FIFO and average cost both a) cost of goods sold b) ending inventory Bridgeport-Mart Centre Inc. opened for business on May 1, and uses a perpetual inventory system. During May, the...

The MEDCOM firm is currently selling for 32, with trailing 12-month earnings and dividends of 1.23 and 0.64, respectively. The Price to Earnings ratio (P/E) is 26, the Price to Book Value ratio...

Mary made her first contribution to a Roth IRA at age 5 2 . When is the first time she can take a qualified tax - free distribution ( assume no disability, death or first - time home purchase )...

Please write new code: 1. Given a square matrix with the elements 0 or 1 , write a program to find a maximum square submatrix whose elements are all 1s. Your program should prompt the user to enter...