Skills Used

• Cumulative Data Analysis: window functions like SUM() OVER (ORDER BY year) to calculate cumulative totals, which is crucial for trend analysis over time.
• Subqueries: using subqueries to filter and process data before joining it with the main query, indicating an understanding of complex query structures.
• Common Table Expressions (CTEs): CTEs with WITH clauses for better organization and readability of SQL queries.
• Data Aggregation and Analysis: Employing aggregate functions (SUM, COUNT) and GROUP BY clauses to summarize and analyze data, revealing trends and patterns.
• Data Ranking: Applying ranking functions such as RANK() to order data sets based on specific criteria.
• Visual Storytelling: Skilled in telling stories with data, translating complex findings into understandable visual formats.