Question: help please(oracle sql) Create a view named order_item_products that returns columns from the Orders, Order_Items, and Products tables This view should return these columns from

help please(oracle sql)

Create a view named order_item_products that returns columns from the Orders, Order_Items, and Products tables

This view should return these columns from the Orders table: order_id, order_date, tax_amount, and ship_date

This view should return these columns from the Order_items table; item_price,

Discount_amount, final_price (the discount amount subtracted from the item price), quantity and item_total(the calculated total for the item).

This view should return the product_name column from the products table

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!