As a hands on Data Science Assignment, you will be working on a real world dataset provided by the Chicago Data Portal. You will be asked questions that will help you understand the data just like a data scientist would. You will be assessed both on the correctness of your SQL queries and results.

A Jupyter notebook has been provided to help with completing this assignment. Follow the instructions to complete all the problems. Then share the Queries and Results with your peers for reviewing.

The total points possible for this assignment are 25 . Here is the breakdown:

• Problem 1: 1 Points

• Problem 2: 1 Points

• Problem 3: 2 Points

• Problem 4: 2 Points

• Problem 5: 2 Points

• Problem 6: 2 Points

• Problem 7: 2 Points

• Problem 8: 4 Points

• Problem 9: 4 Points

• Problem 10: 5 Points

For each problem points will be awarded as follows:

• Full points: Used a correct SQL query that yielded a correct result

• Half or partial points: The query and results are not fully correct

• No points: Did not attempt the problem or did not upload any solution