Learn the basics of SQL and how to create queries. You will learn how to build complex queries and data types with SQLite. The project will use the SQLite syntax.
Used: subqueries, conditional selection, JOINS, aggregate functions, WITH statement, GROUP BY, conditional function CASE
To learn more about this project, please visit HyperSkill Website - School of Wizards and Magic Wars.
This project's difficulty has been labelled as Medium where this is how HyperSkill describes each of its four available difficulty levels:
- Easy Projects - if you're just starting
- Medium Projects - to build upon the basics
- Hard Projects - to practice all the basic concepts and learn new ones
- Challenging Projects - to perfect your knowledge with challenging tasks
This Repository contains:
wizardschool.db - Contains the database on which queries were performed
analysis.sql - Contains the stages' requirements and the sql commands used to achieve them
This project can be run on Visual Studio Code with the SQLite extension (by alexcvzz) installed.