Define a view named ItemOrder. It consists of the TaskID, description, price, order number, order date and quoted price for all order lines currently on file.

Using SQL, write the view definition for ItemOrder.

Write an SQL query to retrieve the TaskID, description, order number, and quoted price for all orders in the ItemOrder view for items with quoted prices that exceed $100.

Convert the query you wrote in Question 3b to the query that the DBMS will actually execute.