I required answers to be run on sql server. Bb Week 7 (10/12 - 10/18) – UML D XMind Tap - Cengage LearningMy Solutions | bartleby+ng.cengage.com/static/nb/ui/evo/index.html?deploymentld=6005692134521536343096290633&elSBN=9780357427859&id=960631992&snapshotld=2029476&Huzaifa vCENGAGE MINDTAPQ Search this courseA My HomeModule 8 Activity 2+Instructions Page 3 of 4query.sqlCoursesWrite your query below and thenclick "Run Query" to execute it.1--Catalog and Study ToolsTask 3:To save multiple queries, clickА-ZPartner Offersthe "+" icoThe Car Maintenance team wants to insert and store the following maintenance types to the2Rental OptionsMAINTENANCE_TYPES table:3College Success TipsID : 1; Description : Tire Change; Price : 50Career Success TipsID : 2; Description ; Oil Change; Price : 45ID : 3; Description ; Full Cleaning; Price : 100You are eligible for a FREE 7-day trial of Cengage Unlimitedor Cengage UnlimitedID : 4; Description ; Gas Pump Change; Price : 145eTextbooksTaskTry for FreeAdd the four maintenance types to the MAINTENANCE_TYPES table.9 SQL ViewerLearn more? HelpTask 4:Give FeedbackThe Car Maintenance team wants to add new maintenance tasks into the system. The team hasdetermined that there should be Tire Change (ID: 1) task for every car with the model yearRun a SQL query to generate results2018 in InstantRide. Due date of this maintenance tasks is 31 December, 2020. Insert the rowsinto the MAINTENANCES table for every car built in 2018 and send the data back to the team.Task3/4..+II Bb Week 7 (10/12 - 10/18) – UML D XMind Tap - Cengage LearningMy Solutions | bartleby+ng.cengage.com/static/nb/ui/evo/index.html?deploymentld=6005692134521536343096290633&elSBN=9780357427859&id=960631992&snapshotld=2029476&Huzaifa vCENGAGE MINDTAPQ Search this courseA My HomeModule 8 Activity 2+Instructions Page 4 of 4query.sqlCoursesWrite your query below and thenclick "Run Query" to execute it.1--Catalog and Study ToolsTask 5:To save multiple queries, clickА-ZPartner Offersthe "+" icoThe Driver Relationship team realized that there is no need forRental OptionsDRIVER_DRIVING_LICENSE_CHECKED field in the active drivers table. Since all the drivers are3already active in InstantRide, their driving licenses should be checked regularly. The teamCollege Success Tipswanted you to remove the field from the table.Career Success TipsTaskYou are eligible for a FREE 7-day trial of Cengage Unlimitedor Cengage UnlimitedRemove the DRIVER_DRIVING_LICENSE_CHECKED field from the ACTIVE_DRIVERS table.eTextbooksTask 6:Try for FreeThe Car Maintenance team wants to update the price of Oil Change to 75. In addition, they will9 SQL ViewerLearn moreno longer provide or require a Gas Pump Change in the future and there is no need to keep the? Helpmaintenance item in the database. Update the cost of the oil change and remove the gas pumpchange option from the MAINTENANCE_TYPES table.Give FeedbackTaskRun a SQL query to generate resultsUpdate the maintenance type information4/4+II

Question

I required answers to be run on sql server. Bb Week 7 (10/12 - 10/18) – UML D XMind Tap - Cengage LearningMy Solutions | bartleby+ng.cengage.com/static/nb/ui/evo/index.html?deploymentld=6005692134521536343096290633&elSBN=9780357427859&id=960631992&snapshotld=2029476&Huzaifa vCENGAGE MINDTAPQ Search this courseA My HomeModule 8 Activity 2+Instructions Page 3 of 4query.sqlCoursesWrite your query below and thenclick "Run Query" to execute it.1--Catalog and Study ToolsTask 3:To save multiple queries, clickА-ZPartner Offersthe "+" icoThe Car Maintenance team wants to insert and store the following maintenance types to the2Rental OptionsMAINTENANCE_TYPES table:3College Success TipsID : 1; Description : Tire Change; Price : 50Career Success TipsID : 2; Description ; Oil Change; Price : 45ID : 3; Description ; Full Cleaning; Price : 100You are eligible for a FREE 7-day trial of Cengage Unlimitedor Cengage UnlimitedID : 4; Description ; Gas Pump Change; Price : 145eTextbooksTaskTry for FreeAdd the four maintenance types to the MAINTENANCE_TYPES table.9 SQL ViewerLearn more? HelpTask 4:Give FeedbackThe Car Maintenance team wants to add new maintenance tasks into the system. The team hasdetermined that there should be Tire Change (ID: 1) task for every car with the model yearRun a SQL query to generate results2018 in InstantRide. Due date of this maintenance tasks is 31 December, 2020. Insert the rowsinto the MAINTENANCES table for every car built in 2018 and send the data back to the team.Task<>3/4..+II Bb Week 7 (10/12 - 10/18) – UML D XMind Tap - Cengage LearningMy Solutions | bartleby+ng.cengage.com/static/nb/ui/evo/index.html?deploymentld=6005692134521536343096290633&elSBN=9780357427859&id=960631992&snapshotld=2029476&Huzaifa vCENGAGE MINDTAPQ Search this courseA My HomeModule 8 Activity 2+Instructions Page 4 of 4query.sqlCoursesWrite your query below and thenclick "Run Query" to execute it.1--Catalog and Study ToolsTask 5:To save multiple queries, clickА-ZPartner Offersthe "+" icoThe Driver Relationship team realized that there is no need forRental OptionsDRIVER_DRIVING_LICENSE_CHECKED field in the active drivers table. Since all the drivers are3already active in InstantRide, their driving licenses should be checked regularly. The teamCollege Success Tipswanted you to remove the field from the table.Career Success TipsTaskYou are eligible for a FREE 7-day trial of Cengage Unlimitedor Cengage UnlimitedRemove the DRIVER_DRIVING_LICENSE_CHECKED field from the ACTIVE_DRIVERS table.eTextbooksTask 6:Try for FreeThe Car Maintenance team wants to update the price of Oil Change to 75. In addition, they will9 SQL ViewerLearn moreno longer provide or require a Gas Pump Change in the future and there is no need to keep the? Helpmaintenance item in the database. Update the cost of the oil change and remove the gas pumpchange option from the MAINTENANCE_TYPES table.Give FeedbackTaskRun a SQL query to generate resultsUpdate the maintenance type information<>4/4+II

Accepted Answer

The SQL query is written to run and get the desired output.
Four tables are created
 
CREATE TABLE…