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!