An SQL analysis the relationship between reported crimes in Chicago and the average daily temperature from 2018 through 2023.
This analysis is intended to answer the following questions:
.List the total number of reported crimes between 2018 and 2023?
.List the total amount of Homicides, Batteries and Assaults reported between 2018 and 2023.
.Which are the 3 most common crimes reported and what percentage amount are they from the total amount of reported crimes?
.What are the top ten communities that had the MOST amount of crimes reported? Include the current population, density and order by the number of reported crimes.