Checkpoint: the film site
A checkpoint on subqueries, EXISTS, CTEs and window functions. Five problems on a film review site, including a bug to find, with no scaffolding.
- The skill
- Solve multi-step questions with subqueries, CTEs and window functions on your own.
- You make
- Five answers about a film review site, including a bug to find.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 24 Running totals and LAG. Free to try: SQL Foundations and the playground.
Cleared
Go back to
You can now
Step 1 of 6
exercise_1.sql
You've reached the good stuff.
5 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite