Define a view named Item Order. It consists of the item number, description, price, order number, order date, number ordered, and quoted price for all order lines currently on file.
a. Using SQL, write the view definition for Item Order.
b. Write an SQL query to retrieve the item number, description, order number, and quoted price for all orders in the Item Order view for items with quoted prices that exceed $100.
c. Convert the query you wrote in Question 3b to the query that the DBMS will actually execute.