socioeconomic_analysis

Overview

The objective of this project is to analyze the socio-economic in Chicago.

Dataset

The dataset is from an IBM SQL course via Coursera. Data copyright © 2020 City of Chicago. The dataset can be downloaded at kaggle.com

Tool/Software

• Microsoft SQL Server

Problem

• Problem 1: How many rows are in the dataset?
• Problem 2: How many community areas in Chicago have a hardship index greater than 50.0?
• Problem 3: What is the maximum value of hardship index in this dataset?
• Problem 4: Which community area which has the highest hardship index?
• Problem 5: Which Chicago community areas have per-capita incomes greater than $60,000?

Algorithm

1. Create database and use database
2. Import dataset
3. Analyze using SQL query

   • Problem 1: How many rows are in the dataset?

     

   • Problem 2: How many community areas in Chicago have a hardship index greater than 50.0?

     

   • Problem 3: What is the maximum value of hardship index in this dataset?

     

   • Problem 4: Which community area which has the highest hardship index?

     

   • Problem 5: Which Chicago community areas have per-capita incomes greater than $60,000?

     

Thank You!