>_BeginnerCoder
Donate

Lesson 20 — Correlated subquery

A subquery per row

A correlated subquery references the outer row — e.g. rows above their groups average.

Why it matters: it answers per-group comparison questions.

Task

Show products priced above the average.

← Back
Next →

Enjoying this lesson? Share it 👇

Keep going with Databases & SQL

Ready for more? These paid resources pick up where this lesson leaves off.

Some links on this page are affiliate links: we may earn a commission at no extra cost to you. We only recommend tools we believe are genuinely useful.