6. Using nested subqueries in SQL, find the names of all vehicle manufacturers who have plant locations in Michigan and whose stock has not been completely sold out yet at Reggie's dealership.

Extracted text: 6. Using nested subqueries in SQL, find the names of all vehicle manufacturers who have plant locations in Michigan and whose stock has not been completely sold out yet at Reggie's dealership.


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.