Peer-graded Assignment: Submit Your Work and Review Your Peers >> Databases and SQL for Data Science with Python
You have been hired by an organization that strives to improve educational outcomes for children and young people in Chicago. Your job is to analyze the census, crime, and school data for a given neighborhood or district. You will identify causes that impact the enrollment, safety, health, environment ratings of schools. You will be required to answer questions similar to what a real life data analyst or data scientist would be tasked with. You will be assessed both on the correctness of your SQL queries and results.
A Jupyter notebook is provided to help you complete this assignment. Follow the instructions to complete all the problems, then share the Queries and Results with your peers for review.
Example Submissions
Here is an example of a submission clearly showing both the SQL Query and its Results/output, when executed from a Jupyter notebook.
Important aspects of the submission are highlighted below for illustrative purposes:
Assignment Solution :
Problem 1: Find the total number of crimes recorded in the CRIME table
Problem 2: Retrieve first 10 rows from the CRIME table
Problem 3: How many crimes involve an arrest?
Problem 4: Which unique types of crimes have been recorded at GAS STATION locations?
Problem 5: In the CENUS_DATA table list all Community Areas whose names start with the letter ‘B’.
Problem 6: Which schools in Community Areas 10 to 15 are healthy school certified?
Problem 7: What is the average school Safety Score?
Problem 8: List the top 5 Community Areas by average College Enrollment
Problem 9: Use a sub-query to determine which Community Area has the least value for school Safety Score?
Problem 10: (Without using an explicit JOIN operator) Find the Per Capita Income of the Community Area which has a school Safety Score of 1.
