The demo now covers all of Module 1, boss included, instead of stopping after five questions.
What's new
- 18 questions instead of 5. The five guided questions are still the opening. The next thirteen cover AND/OR precedence, sorting and LIMIT, CASE, NULLs, pattern matching, dates and text functions. Every question still has hints and a lesson tab.
- The Module 1 boss. The last question asks for page 2 of a filtered, labelled, rounded and sorted trade log. Tsumugi has a short scene before it, and a manga panel plays when you beat it.
- Two optional side questions. Partway through, you can look at two tables the course catalog does not list. They don't count toward finishing the module, so you can skip them.
- An outfit pull. Solve question 3 and Tsumugi hands you one pull. Turn the crank and she gets her Stage Idol outfit. You can switch between it and her uniform for the rest of the demo.
- Texts from Tsumugi. After question 2, she starts texting you. Eight messages across Module 1, four of them with photos, and two you can reply to.
- The order a query is read in. After question 5, a short pop-up walks through the logical order of your SQL: FROM, then WHERE, then SELECT, then ORDER BY. A button on question 5 opens it again.
- New title intros. The title screen opens with a mosaic or a stained-glass window, taking turns each launch. You can turn the intro off next to the music controls.
- Music. The workspace now changes tracks as you solve, and Shuffle music plays its three tracks in random order.
- A new end screen after the boss.
- Fixes: column names like user_id are no longer coloured as if they were functions in the editor, and the Back links in the drills now point back.
The title intro, the pull and the pop-up can be skipped with a key press or a click, and the system's reduced-motion setting turns their animation off.
The 24 optional drills are still there once you finish the module, or any time from the demo home.
If something breaks or reads wrong, please post it in the Steam discussions.