Checkpoint: summing up the launcher
A checkpoint on NULL, aggregates, GROUP BY, HAVING and CASE. Six questions about a month of play on a game launcher, with no scaffolding.
- The skill
- Summarise a game launcher's data per game, per player and per genre on your own.
- You make
- Six reports for a game launcher, including a bug to find.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 11 CASE, if-then inside a query. Free to try: SQL Foundations and the playground.
Cleared
Go back to
You can now
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