An adventure into AdventureWorks

Below are sample queries I've written against a local database populated with Microsoft's AdventureWorks sample data.

To learn more about AdventureWorks you can read this short blog post here.

This query is an example of how I employ SQL leveraging common table expressions (CTEs), different types of joins, window functions, where statements using dates and aggregate functions.

With this query I demonstrate how I use several of the strategies from the above query like common table expressions, various joins and aggregate functions in addition to employing case when statements.