Vehicle Dealership Database: Consider Reggie's dealership, a multi-brand vehicle dealership whose database consists of four relations as described below. Vehicle(make, model, manlkear, color, vinNum,...

Extracted text: Vehicle Dealership Database: Consider Reggie's dealership, a multi-brand vehicle dealership whose database consists of four relations as described below. Vehicle(make, model, manlkear, color, vinNum, type, purshassld) Stock(stockNum, uniterice deliverxlate. vehicleskemainina) Manufacturer(name, manilede elantlocation) Purchase(purchaseld. mGede. numKehicles, erderDate. delixerxStatus) A vehicle can be one of the following types: Car, Truck, SUV vinNum - Vehicle Identification Number is made up of 17 characters (alphanumeric) mantXear → year of vehicle manufacture mantCede/ mCede- a 4.character alphanumeric code for the manufacturer • RUurshaseld, and steckNum refer to the same item • Each individual order consists of the same type of vehicle. For example, • Order#1 - 35 cars Order#2 - 50 SUV's Order#3 - 20 trucks The delivery status is true if the order has been delivered to the dealership and false otherwise.


Extracted text: 8. Using a subquery in the FROM clause, find the average unit price of in-stock trucks of any make/model in SQL.