Question: *PLESE SHOW ALL THE STEPS IN THE SQL CODE TO GET TO THE ANSWER IN PART 1* Overview: You have a job interview. They have
*PLESE SHOW ALL THE STEPS IN THE SQL CODE TO GET TO THE ANSWER IN PART 1*
Overview:You have a job interview. They have given you the task of writing a summary that explains how you would write a report for one of their clients. They also want you to give a brief explanation justifying the approach you took.
Directions: The potential employer would like you to use a data set called FleetMaintenanceRecords to complete an analysis of data and summarize your findings using clear language for a nontechnical audience. Theyve asked you to find themes that can be used to help them manage their fleet of trucks.
Analyze the data youve been provided to identify themes. Gather the following guiding information:
Review part-replacement frequencies and types and create a hypothesis that can be used by the fleet management team to better deal with vehicle maintenance. Youll need to create a table called Parts Maintenance and load the data into it. Put this table in the database named after yourself. Load this data set from the /home/codio/workspace path and run queries to find the results.
1.)Which parts are being replaced most?
**PLESE SHOW ALL THE STEPS IN THE SQL CODE TO GET TO THE ANSWER IN PART 1 (using Codio)**
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
