PLEASE USE REFERENCE NUMBER FROM PREVIOUS CHEGG QUESTION

https://www.chegg.com/homework-help/questions-and-answers/pre-existing-tables-create-table-based-questionswrite-commands-generate-table-based-asked--q30618529

TO FINISH THESE QUESTIONS PELASE

7. Populate the 4 new tables with the appropriate data using the select into statement with the distinct function.

Paste the SQL statements below.

8. To increase the speed of the queries we will run in the next question create four indexes on the vehicle table for the columns: make, model, drive, and fuelType. There should be non-unique or regular indexes.

Paste the SQL below.

CREATE INDEX indexMake ON vehicleMake(make);

9. Populate vehicleNormal by joining the vehicle, vehicleMake, vehicleModel, vehicleDrive and vehicleFuelType tables.

Paste the SQL below.

10. Write a select statement to return the following fields: vehicle Id, make, model, year, drive, and fuel type. Do not use the vehicle table; instead use the 5 new tables we just created.

Paste the SQL and results below.