Correlated Subqueries

Window Functions

Multiple Table Joins

Get top 3 products per category

Find latest 5 orders per customer

Retrieve most recent status per entity

What is LATERAL join?

LATERAL vs window functions?

When to use LATERAL?