Beginner recap
Nice work — here's everything you just learned.
A quick reference for every concept from the Beginner track, Cases 1–20.
What you've learned
SQL Fundamentals
- SELECT, FROM, WHERECase 001: Finding Nina →
- Comparison operators, BETWEENCase 002: The Expensive Orders →
- LIKE, wildcard pattern matchingCase 003: The Almost-Right Name →
- DISTINCTCase 004: The Product Lineup →
- ORDER BY, LIMITCase 005: The Top Order →
- INNER JOINCase 006: Whose Order Is This? →
Joins & Grouping
- LEFT JOIN, IS NULLCase 007: The Customers Who Never Ordered →
- IN with a literal listCase 008: The Preferred Regions →
- GROUP BY, COUNTCase 009: Orders Per Customer →
- GROUP BY, SUM, HAVINGCase 010: The Big Spenders →
- JOIN + GROUP BY across tablesCase 011: Sales by Category →
- Joining 3+ tablesCase 012: The Full Order Detail →
- Multi-column GROUP BYCase 013: Revenue by Country and Category →
Subqueries & Set Logic
- CASE expressionsCase 014: Small, Medium, or Large →
- UNIONCase 015: The VIP List →
- Date functions, grouping by time periodCase 016: Revenue by Month →
- HAVING with multiple conditionsCase 017: The Loyal High-Value Customers →
- Scalar subqueryCase 018: Above Average →
- EXISTSCase 019: Audio Buyers →
- NOT EXISTSCase 020: Never Bought Accessories →
Twenty cases, start to finish. You went from a single SELECT to writing subqueries and EXISTS checks against real business questions — and you got there by solving every one yourself, not by reading someone else's answer. That's real progress. Take a second to actually feel good about it before Intermediate starts.