Define a view named PartOrder. It consists of the part 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 PartOrder.
b. Write an SQL query to retrieve the part number, description, order number, and quoted price for all orders in the PartOrder view for parts with quoted prices that exceed $100.
c. Convert the query you wrote in Question 3b to the query that the DBMS will actually execute.