An SQL analysis of reported crimes in Chicago and the average daily temperature in 2021.
Download Excel/Google Sheets with the most common SQL queries output.
Three key datasets for this case study
- chicago_areas.csv: Chicago neighborhoods and areas.
- chicago_crimes_2021.csv: Reported crimes in 2021.
- chicago_temps_2021.csv: Average city temperatures.