h) Create the following VIEWS. Copy-paste the relevant SQL script below each bullet. View name: INSTOCK [4] (Inventory code, Year, Make, Model, Trim Line, VIN number, exterior color, interior color, listed price, dealer name) for only those vehicles in inventory that are available for sale. Query view above to retrieve listing (all attributes) of cars whose make is Honda or Ford. [2]

View name: INSTOCKUSED [5] (Inventory code, Year, Make, Model, Trim Line, VIN number, exterior color, interior color, mileage, listed price, blue book value, dealer name) for only used vehicles in inventory that are available for sale. Note: used vehicles are denoted by U or u values for new or used.

Query view above to retrieve listing (all attributes) of cars whose make is Honda or Ford. The list should only consist of cars with mileage under 50000, or listed price is no more than 90% of blue book value.