Climate Case Study Through SQL Intro
Climate Case Study Through SQL
Perform risk analysis of climate change on humans by measuring air quality metrics for different locations in the United States.
Learn the following SQL Concepts:
- How to get N rows of data in SQL
- How to find missing data in SQL
- How to use Aggregate Functions in SQL
- Count, Count Distinct, Sum, Maximum, Minimum etc.
- How to Group data and aggregate in SQL
- How to combine Filtering, Grouping and Sorting in SQL
- How to use AND and OR multiple filtering conditions in SQL
- How to write a subquery in SQL
- How to use Subqueries as Filtering conditions in SQL
- How to use Subqueries as a Case When condition in SQL
- How to use Mathematical Functions on Aggregate Values in SQL
- How to use Window Functions in SQL
- How to Rank within a group using RANK OVER() Function in SQL
- How to create a CTE (Common Table Expression) in SQL
- How to convert an aggregate column to percentage in SQL
Learn the following Concepts about Climate Data Science:
- Understand the various climate air quality metrics
- How to analyze the at risk population based on high Ozone levels
- How to analyze the at risk population based on high PM25 levels
- How to rank states based on maximum population exposed to bad air quality
- How to find the state-wise low income population
- How to analyze the low-income population's exposure to bad air quality
- How to find the best & worst blocks within each state based on air quality indicators
- How to calculate total population at risk to air toxic cancer
- How to calculate low income population at risk to air toxic cancer