In this article we will cover:



Advanced Aggregations
Advanced Set Operations
Window Functions
CTEs and Query Structuring
Subqueries
EXISTS vs NOT EXISTS
Query Optimization



Most real-world insights come from combining multiple SQL techniques.


While a basic understanding of SQL e.g. selecting columns, filtering rows, and joining tables is...