Complete the following questions in the query using SQL Developer 1. The TOYS view is no longer
Question:
Complete the following questions in the query using SQL Developer
1. The TOYS view is no longer necessary, try to delete it. Confirm the removal of TOYS view by using select view_name from user_view
2. For each order, list the order number and order date along with the number and name of the customer that placed the order.
3. Display item number and description for items that have not been ordered.
4. Display the customer number, customer name, order number, and order date for each order. Sort the results by order date by descending sequence.
5. For each order line, what is the amount of discount, and percent discount is given. Discount is based on the difference between price and quoted_price. Report order number, order date, discount amount, and discount percent. Percentage of discount is based on difference_ in_ price/price*100
6. For each order report order number, order date, and discount percent.
n
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi