SQL projects on DataCamp

📊 Guided projects

1. Analyze International Debt Statistics

Aggregate data with SUM(), MAX(), MIN()
Filter rows using WHERE, GROUP BY
Use subquery in WHERE

View my project here!

2. Analyzing NYC Public School Test Result Scores

Count unique values with COUNT(DISTINCT)
Combine SUM() and COUNT() to calculate in each row

View my project here!

3. When Was the Golden Age of Video Games?

Use HAVING to filter on results of GROUP BY
JOIN and LEFT JOIN tables

View my project here!

4. Analyzing American Baby Name Trends

UseCASE to add a new column based on some conditions
Use window functions such as DENSE_RANK(), SUM()
Simplify the code with CTE

View my project here!

5. Optimizing Online Sports Retail Revenue

CAST numeric data
Calculate the correlation and median
Work with dates, times, and strings

View my project here!

📊 Unguided projects

1. Analyzing Unicorn Companies

View my project here!

2. Analyzing Motorcycle Part Sales

View my project here!