Hey everyone! Thanks for playing and for all the kind feedback so far! :)
This newest update should overall improve stability and make the goal of the last level clearer.
Please let me know if you have any more feedback!
Update Notes:
Gameplay Changes
Update evidence in level 4 to clarify which conventions the suspect went to.
Update textbook chapter 4 to clarify what is allowed when using aggregate functions.
If more than one table is being selected, throw an error if not every table is joined together (prevent inadvertent cross joins).
This technically isn’t a requirement in SQL, but there’s not really a reason to do a cross join in this game. Even in practical real life circumstances it’s rare. Plus, it’s really easy to build up massive queries that crash the game, which can happen if you’re not careful with your join conditions.
Remove song from music player that was causing YouTube copyright strikes
Add a couple more royalty free tracks.
Fixes
Increased audio volume from the messages panel.
Made the music player volume slider less sensitive.
Update to the newest version of Unity due to security vulnerability
Added some optimization for the loading of table panels.
Table panels will now load more data once you scroll all the way to the bottom.
This isn’t really relevant for the demo but in the full release some tables get really large so I want to ensure the experience stays consistent.