304 North Cardinal St.
Dorchester Center, MA 02124

# Databases and SQL for Data Science with Python Peer-graded Assignment Solution

## Peer-graded Assignment Instruction

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.

### Exercise 1 – Question 1

Write and execute a SQL query to list the school names, community names and average attendance for communities with a hardship index of 98. Take a screenshot showing the SQL query and its results. Upload the JPEG (.jpg) file below for your peers to review

### Question 02

Write and execute a SQL query to list all crimes that took place at a school. Include case number, crime type and community name. Take a screenshot showing the SQL query and its results. Upload the JPEG (.jpg) file below for your peers to review

### Exercise 2 – Question 1

Write and execute a SQL statement that returns just the school name and leaders’ icon from the view. Take a screenshot showing the SQL query and its results. Upload the JPEG (.jpg) file below for your peers to review

### Exercise 3 – Question 1

Write the structure of a query to create or replace a stored procedure called UPDATE_LEADERS_SCORE that takes an in_School_ID parameter as an integer and an in_Leader_Score parameter as an integer. Don’t forget to use the #SET TERMINATOR statement to use the @ for the CREATE statement terminator. Take a screenshot showing the SQL query. Upload the JPEG (.jpg) file below for your peers to review

### Exercise 03 – Question 02

Inside your stored procedure, write a SQL statement to update the Leaders_Score field in the CHICAGO_PUBLIC_SCHOOLS table for the school identified by in_School_ID to the value in the in_Leader_Score parameter. Take a screenshot showing the SQL query. Upload the JPEG (.jpg) file below for your peers to review

### Exercise 03 – Question 03

Inside your stored procedure, write a SQL IF statement to update the Leaders_Icon field in the CHICAGO_PUBLIC_SCHOOLS table for the school identified by in_School_ID using the following information. Take a screenshot showing the SQL query. Upload the JPEG (.jpg) file below for your peers to

### Exercise 03 – Question 04

Run your code to create the stored procedure.

Take a screenshot showing the SQL query and its results. Upload the JPEG (.jpg) file below for your peers to review.

### Exercise 04 – Question 01

Update your stored procedure definition. Add a generic ELSE clause to the IF statement that rolls back the current work if the score did not fit any of the preceding categories.

Take a screenshot showing the SQL query. Upload the JPEG (.jpg) file below for your peers to review.

### Exercise 04 – Question 02

Update your stored procedure definition again. Add a statement to commit the current unit of work at the end of the procedure.

Take a screenshot showing the SQL query. Upload the JPEG (.jpg) file below for your peers to review.

##### Conclusion:

I hope this Databases and SQL for Data Science with Python Peer-graded Assignment Solution would be useful for you to learn something new from this Course. If it helped you then don’t forget to bookmark our site for more peer graded solutions.

This course is intended for audiences of all experiences who are interested in learning about new skills in a business context; there are no prerequisite courses.

Keep Learning!

More Peer-graded Assignment Solutions >>

Boosting Productivity through the Tech Stack Peer-graded Assignment Solutions

Essential Design Principles for Tableau Peer-graded Assignment Solutions

Creating Dashboards and Storytelling with Tableau Peer-graded Assignment Solutions

Intro to AR/VR/MR/XR: Technologies, Applications & Issues Graded Assignments

Conversational Selling Playbook for SDRs Peer-graded Assignment Solution