SQL EXERCISES

It is a repository with SQL queries exercises. These exercises are available in sqlzoo.net.

Solved Using

Database engine MySQL or MariaDB, only available in sqlzoo.net

You can go to sqlzoo.net and learn using the tutorials:

0 SELECT basics: Some simple queries to get you started.
1 SELECT name: Some pattern matching queries.
2 SELECT from World: In which we query the World country profile table.
3 SELECT from Nobel: Additional practice of the basic features using a table of Nobel Prize winners.
4 SELECT within SELECT: In which we form queries using other queries.
5 SUM and COUNT: In which we apply aggregate functions.
6 JOIN: In which we join two tables; game and goals.
7 More JOIN operations: In which we join actors to movies in the Movie Database.
8 Using Null: In which we look at teachers in departments.
8+ Numeric Examples: In which we look at a survey and deal with some more complex calculations.
9- Window function: In which we examine UK general election results.
9 Self join: In which we join Edinburgh bus routes to Edinburgh bus routes.
10 Tutorial Quizzes: Test your knowledge with multiple choice quizzes

👤 Sergio Zambrano

Contributions, issues and feature requests are welcome!. Feel free to check the issues page.

Give a ⭐️ if you like this project!

This project is MIT licensed.