Opening book details…
Can I read Chicago Crime Data Analysis Queries on EtoBox?
Chicago Crime Data Analysis Queries by kumar is a document available to read on EtoBox.
What is Chicago Crime Data Analysis Queries about?
The document contains 9 SQL queries to analyze data from 3 databases: CENSUS_DATA, CHICAGO_PUBLIC_SCHOOLS, and CHICAGO_CRIME_DATA. The queries find crime statistics, community area details, school safety scores, and poverty rates. Problems 8-10 use subqueries to identify the most crime-prone community area and the area with the highest hardship index and most crimes.
- Author
- kumar
- Language
- EN