SQL Fragmenten

Join customers and orders, project a flat report.

Aggregate customer spend and filter high-value accounts.

Rank orders by total within each customer.

Walk a category tree from the root down.

Insert or update on conflict (PostgreSQL syntax).

Accelerate a common query with a multi-column index.