Project
School of Wizards and Magic Wars
Medium
117 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
2 hours ago
Interesting but not very challenging. You will essentially practice JOIN, GROUP BY and aggregate functions.
2 months ago
It is rated as difficult, but some projects (Airline transportation, Payroll management database) rated as medium are much more difficult. I would expect here more complex tasks. Simple JOIN, GROUP BY, HAVING is essential and not challenging.
Jeroen Taheij
6 months ago
Nothing new other then that this project is listed under challenging, but is far easier the projects listed under medium.
4.3
Learners who completed this project within the Databases with SQL and Python course rated it as follows: