Overview
You are a data analyst for an insurance company. Your assignment is to find the three boroughs in New York City with the highest accident rates. The company will use this report to calculate the insurance rates to charge customers living in those areas.
Prompt
In the Virtual Lab using MySQL, create a report to explain some specifics your company seeks to aid in decision making. You will need to define your parameters and extract the necessary data to see the number of traffic accidents in each borough to determine which three have the highest incidence of traffic accidents. Your data report should include only the relevant information for the three boroughs with the highest rates.
Your report should include 1–2 paragraphs per section, documenting specific details of analytical findings. Include accompanying screenshots as necessary. You must address the following rubric criteria:
Define your parameters.
Determine the three boroughs with the highest number of accidents.
Extract the necessary data for reporting the three boroughs with the highest accident rates.
Please use attached file
Overview You are a data analyst for an insurance company. Your assignment is to
Important - Read this before proceeding
These instructions reflect a task our writers previously completed for another student. Should you require assistance with the same assignment, please submit your homework details to our writers’ platform. This will ensure you receive an original paper, you can submit as your own. For further guidance, visit our ‘How It Works’ page.
