Project
School of Wizards and Magic Wars
Medium
142 completions
~ 9 hours
4.3Learn 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.
Provided by
JetBrains Academy
About
Several disciples returned to take revenge from the wizarding school they were expelled from. The headmaster requires brave and smart students to defend the school. Are you ready to help him with this?
Training project
This project allows you to practice and strengthen your coding skills, helping you get ready for more advanced tasks ahead.
What you'll learn
Once you choose a project, we'll provide you with a study plan that includes all the necessary topics from your course to get it built. Here’s what awaits you:
Find the top 3rd grade students.
Find students with the best achievements.
Find students with above-average grades.
Give the prizes to the best ones!
Reviews
YK
Yaraslau Krautsou3 months ago
I learned how to write complex SQL queries using joins, aggregate functions, grouping, and conditional expressions to extract specific insights from a multi‑table database. The biggest difficulty was figuring out the exact table and column names when the schema wasn’t fully visible—I had to carefull ...
5 months ago
This project was a great introduction to database querying. I have found it quite entertaining and not stressful at all. I recommend it to whomever wants to upgrade their SQL skills.
7 months ago
I have learned basics in SQLite, SELECT-FROM, CASE, JOIN, HAVING, GROUP BY, ORDER BY, SUM(), COUNT(), AVG().
4.3
Learners who completed this project within the Databases with SQL and Python course rated it as follows: