Question: please answe this ASAP Question 2 (15 points) The Wrecks 'R Us Auto Repair Shoppe has a database to keep track of cars, repair orders,
Question 2 (15 points) The Wrecks 'R Us Auto Repair Shoppe has a database to keep track of cars, repair orders, and repair technicians. The database has the following tables: Carvin, make, model, year) -- car vehicle ID #, manufacturer, model, and year; for example: (17234, Toyota, Prius, 2008) or (38953, Chevy, Nova, 1968). Technician(techid, name, yearhired) -- technician ID number, name, and year hired. CanFix(techid, make, model) -- table listing the car makes and models that a technician can fix. Order(num, vin, techid, year, month, day) -- repair order #, car ID, technician ID, and date. Write a SQL query that lists the names of all technicians who were hired before 2005 and can fix a Ford Mustang or a Chevy
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
