We will start this assignment in class, but you will also need to work on it outside of class. In a Word document, answer the following questions and paste the SQL queries you used to get the answer for each question.
- How many records are in the database?
- How many fields?
- How many incidents for each police agency?
- How many crimes per year?
- Which agencies saw the biggest percentage increase in crime from 2012 to 2014?
- Which agency has the most reports that don’t name anyone involved in the incident?
- Who is the most common person reported as involved in an incident?
- How times was Kmart involved in an incident?
- How many crimes were reported during the 5 p.m. hour?
- How many total crimes were reported in the 27517, 27510 and 27514 zip codes?
- What is the oldest age of person involved in an incident?
- What is the youngest age?
- What is the average age?
- Create a list of the names of the 65-year-olds who were involved in incidents.
- How many people live in the zip code with the most crimes?