Final challenge: the film database
The SQL track's final challenge. Six problems on a film database, from grouping and CASE to window functions, a view and a join bug. Clear it to finish SQL.
- The skill
- Answer a film site's questions from joins to window functions, on your own.
- You make
- The final challenge: six problems on a film review database.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 32 Bug hunt: fix code you did not write. Free to try: SQL Foundations and the playground.
Cleared
Go back to
You can now
You can now
- Answer real questions from a database on your own
- Join, group and summarise data across several tables
- Break hard questions into steps with CTEs and window functions
- Design tables with keys, constraints, views and indexes
- Change data safely with transactions
- Find and fix queries that run and still give the wrong answer
Step 1 of 7
exercise_1.sql
You've reached the good stuff.
6 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite