Mindtap Cengage assignment E/././17goInstantRide is the new ride sharing application in the city and ithas just started its operations. With the help of the Instant Ridemobile application, the users request a ride with their location.Drivers and cars are assigned to the request; and then the driverpicks up the user to ride their requested location. Information forthe users, drivers and cars are stored in the database as well as thetravel transactions.In the USERS table, information for the users are stored with theirfirst name, last name and email:USER ID3002200330043005300630073008USERS TableUSER FIRST NAMEJackRyanNursinSarahBobbyRandyJoseNursinUSER LAST NAMECollinsVilmarFriceGriffinClarkThomasHIHAPE THEYılmazUSER_EMAIL35Jhill@xmail.comr.collins@xmail.comn.atak@gmail.coms.price@xmail.comLAMPOR RE5041b.griffin@xmail.comr.clark@xmail.comj.thomas@xmail.comMASK ETHOSn.yilmaz@xmail.comNSQL Vie Sss Tipss TipsYOUrms</>gº⑤อInsert two maintenance types in a batch to theMAINTENANCES table.Add a tire change maintenance task for every car androllback the changes.Remove the ACTIVE_DRIVERS table.Create the ACTIVE_DRIVERS VIEW for working withactive drivers.Update a driver's record using the ACTIVE_DRIVERSVIEW.Insert a new driver record into the DRIVERS table usingthe auto increment on the driver's id.EA>>.>2SQL

Since there are multiple questions, the first full question is answered for you. Please post the rest of the questions separately.1. First, assume that the Car Id column name is CAR_ID, the Maintenance Type column name is MAINTENANCE_TYPE_ID, the Due column name is MAINTENANCE_DUE and the Table name is MAINTENANCES. So if we want to insert records in MAINTENANCES then we need to write the below script. START TRANSACTION; Insert into MAINTENANCES VALUES('1001', '2', '2020-06-01'); Insert into MAINTENANCES VALUES('1003', '2', '2020-06-01'); COMMIT;