Databases and SQL for Data Science with Python Final Project
Used SQL to analyze 3 datasets: Chicago Socioeconomic Indicators, Chicago Public Schools, and Chicago Crime Data from the Chicago Data Portal.
Answered the following 10 questions:
Problem 1: Find the total number of crimes recorded in the CRIME table.
Problem 2: List community areas with per capita income less than 11000.
Problem 3: List all case numbers for crimes involving minors?
Problem 4: List all kidnapping crimes involving a child (children are not considered minors for the purposes of crime analysis)?
Problem 5: What kind of crimes were recorded at schools?
Problem 6: List the average safety score for all types of schools.
Problem 7: List 5 community areas with highest % of households below poverty line.
Problem 8: Which community area(number) is most crime prone?
Problem 9: Use a sub-query to find the name of the community area with highest hardship index.
Problem 10: Use a sub-query to determine the Community Area Name with most number of crimes?