Correlated Subqueries Deep Dive

Window Functions

JOIN with Aggregation

Compare to department average

Find above/below group average

What is correlated subquery?

Performance implications?

Alternatives?

Correlated Subqueries

Performance Optimization