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

• Use CASE 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