Update MazePuzzle: Dynamic Puzzle Variants Using Order By and Where SQL Statements

[ASPE-Summa]

Overview

Enhance the MazePuzzle to provide users with a puzzle focused on practicing SQL 'ORDER BY' and 'WHERE' clauses. The MazePuzzle should support multiple variants so that the puzzle can change each time, preventing users from memorizing a single solution.

Objectives

• Design the MazePuzzle so that it generates puzzles requiring the use of both 'ORDER BY' and 'WHERE' SQL statements to solve.
• Implement a system for multiple puzzle variants, each with different conditions, data, or goals, ensuring a variety of correct solutions.
• On each puzzle attempt, randomly select one variant to present to the user.
• Ensure the UI and backend logic support evaluating multiple possible correct answers based on the variant selected.

Acceptance Criteria

• MazePuzzle supports at least five distinct variants, each solvable with different combinations of 'ORDER BY' and 'WHERE'.
• Puzzle variant is randomly selected for each user attempt.
• System accepts multiple valid solutions depending on the variant.
• Documentation is updated with instructions and examples for each variant.
• User experience makes it clear which SQL clauses are needed and provides feedback for correct/incorrect answers.

Additional Notes

• Aim to help users practice real-world SQL query construction.
• Consider extensibility for future SQL topics or additional puzzle types.
• Discuss or propose further ideas for new puzzle variants in this issue before implementation.