--DROP OrderItemsTotal
--DROP VIEW OrderItemsTotal

--CREATE VIEW using calculated fields
CREATE VIEW OrderItemsTotal AS
SELECT order_num,
		prod_id,
		quantity,
		item_price,
		quantity * item_price AS Calculated_Price
FROM OrderItems

--review the OrderItemsTotal VIEW for testing purposes - VIEW must exist BEFORE executing
--SELECT *
--FROM OrderItemsTotal

