Subqueries in WHERE: Which Orders Beat the Average?
All lessons
- Subqueries in WHERE: Which Orders Beat the Average?Free
- IN, EXISTS and the NOT IN Trap: One NULL That Returns Nothing Locked
- Correlated Subqueries: Above the Customer's Own Average & the Latest Order Locked
- CTEs Step by Step: Three Helper Tables, Each Checked Before the Next Locked
- UNION vs UNION ALL: Stacking Two Exports and Removing Duplicate Rows Locked
- INTERSECT and EXCEPT: Rows in Both Lists, Only in A, Only in B Locked
- Self-Joins and Date Spines: Managers, Reporting Levels & Zero-Filled Days Locked
- Mid-course project: NULL Logic, COALESCE and a Monthly Report That Reconciles Locked
- Subqueries in SELECT and FROM: Each Customer's Share and a Filter on a Derived Table Locked
- WHERE vs HAVING: Filtering Rows Before and Groups After the Sum Locked
- ANY and ALL: Comparing a Row with Every Value of a Subquery Locked
- Join Fan-Out: Why a Join Inflates the Revenue and How to Pre-Aggregate Locked
- CASE and Conditional Aggregation: Size Buckets and a Pivot Without PIVOT Locked
- Counting Right: COUNT(*), COUNT(column), COUNT(DISTINCT) and AVG with NULLs Locked
- Recursive CTEs: Walking a Parts List Level by Level Locked
- CROSS JOIN: Every Store × Every Product and the Combinations Never Sold Locked
- Relational Division: Customers Who Bought Every Product of a Set Locked
- Range Joins: Matching Each Order to the Price Valid on Its Date Locked
- Testing a Query: Duplicate Keys, Orphan Rows and Totals That Must Match Locked
- Final Project: A Customer Status Report from Five Query Steps Locked
You are not signed in — the lab works, but your progress is not saved. Sign up
✓ Lesson 1 complete
You finished 1 of 20 labs
Keep going with SQL Beyond the Basics in a Spreadsheet: Subqueries, IN & EXISTS, Correlated Subqueries, Step-by-Step CTEs, UNION vs UNION ALL, INTERSECT & EXCEPT, Self-Joins, Date Spines & NULL Logic: 19 more hands-on labs, the final exam and your certificate.
Continue for $9.90One-time payment, no subscription.
Loading the spreadsheet…