DAD 220 5-2 Analysis and Summary Template
1.Analyze the data you’ve been provided with to identify themes:
a.Which parts are being replaced most?
[ Fuel Tanks are being replaced the most with 95 repairs ]
Command Used: SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
GROUP BY PART_REPAIR ORDER BY NUMBER_OF_REAPAIRS DESC
b.Is there a region of the country that experiences more part failures and replacements than others?
i.Identify region [ MIDWEST REGION with 260 Repairs ]
Commands Used:
SELECT "SOUTHWEST" AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
WHERE UPPER(state) IN ('AZ','NM','TX','OK')
UNION
SELECT "SOUTHEAST" AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
1.Analyze the data you’ve been provided with to identify themes:
a.Which parts are being replaced most?
[ Fuel Tanks are being replaced the most with 95 repairs ]
Command Used: SELECT repair AS PART_REPAIR, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
GROUP BY PART_REPAIR ORDER BY NUMBER_OF_REAPAIRS DESC
b.Is there a region of the country that experiences more part failures and replacements than others?
i.Identify region [ MIDWEST REGION with 260 Repairs ]
Commands Used:
SELECT "SOUTHWEST" AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
WHERE UPPER(state) IN ('AZ','NM','TX','OK')
UNION
SELECT "SOUTHEAST" AS REGION, COUNT(*) AS NUMBER_OF_REPAIRS
FROM Parts_Maintenance
