SQLiteracy · Advanced course · Plus
Window functions, set operations, CTEs, and a route-analysis capstone over 18 months of traffic.
For learners fluent in joins and GROUP BY. The 18-month data window exists for these modules: rankings, month-over-month and year-over-year change, moving averages, and eventually the route-analysis capstone.
This course ships with Plus, alongside the full course library. Browse the modules freely; the labs unlock when you upgrade.
Module 1 · ~20 min
Set operations and self-comparison
UNION, INTERSECT, EXCEPT, and the routes that only fly one way
Module 2 · ~22 min
Subqueries and CTEs
WITH clauses, staged thinking, and queries you can read next month
Module 3 · ~22 min
Window functions
Rankings, trends, and time, without collapsing your rows
Module 4 · ~22 min
Grain, scope, and honest averages
When an average answers a different question than the one asked
Module 5 · ~35 min
Capstone: the route analysis brief
One airport, six questions, every module you've finished
Finished the modules? Take the final exam: five fresh questions, no hints, and the SQLiteracy Advanced badge when you pass them all.
Start the examWondering what you've actually learned? Review your skills across every course.
Where this data comes from
Every query in this course runs against real, public-domain data, rebuilt monthly and graded in your browser. The traffic data covers January 2025 through June 2026, and this build was last updated on 18 September 2026.
segments849,295 rowsOne row is one carrier, route, aircraft type and service class in one month. From U.S. Bureau of Transportation Statistics, T-100 Segment, public domain.
airports72,563 rowsOne row is one airport. From OurAirports, public domain.
The database also carries countries, carriers, aircraft_types and service_classes, which this course does not need but the schema panel and the Scratchpad leave open to you.
Sources: BTS T-100, OurAirports. Refreshed monthly. BTS publishes T-100 on a lag, so the most recent month here trails the calendar.