← 🗃️ SQL Deep Dive12 / 25
Lesson 12 — CTEs (WITH)
Name a subquery
A CTE names a temporary result for readability.
Task
Use a CTE to select products under 40.
Keep going with SQL Deep Dive
Ready for more? These paid resources pick up where this lesson leaves off.
UdemyBestsellers
Top-rated SQL Deep Dive courses
Project-based SQL Deep Dive video courses — the perfect paid next step after these free lessons.
Browse on Udemy →AmazonReader picks
Best SQL Deep Dive books
Hand-picked SQL Deep Dive books to master the fundamentals offline.
See on Amazon →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.