SQLZoo

This project is an exercise to learn the basics of SQL.

Exercise questions from https://sqlzoo.net/wiki/ are used to practice the basic SQL commands

Solutions of the queastions under the topics listed below in the websire are given in the 'sqlzoo.sql' file

• SELECT basics
• SELECT from WORLD Tutorial
• SELECT from Nobel Tutorial
• SELECT within SELECT Tutorial
• SUM and COUNT
• The JOIN operation
• More JOIN operations
• NULL, INNER JOIN, LEFT JOIN, RIGHT JOIN
• Self join

To test the sql codes in the 'sqlzoo'

1. Open https://sqlzoo.net/wiki/
2. Open 'sqlzoo.sql' in the root directory
3. Copy the solution codes from the .sql file into the respective questions in the sqlzoo page
4. Run test

Authors

👤 Nikola Zdarle

• GitHub: @zdrale
• Twitter: [@zdralenikola]https://twitter.com/zdralenikola)
• LinkedIn: Nikola Zdrale

👤 Henok Mossissa

• GitHub: @henatan99
• Twitter: @henatan99
• LinkedIn: Henok Mossissa

🤝 Contributing

Contributions, issues, and feature requests are welcome!

Show your support

Give a ⭐️ if you like this project!

📝 License

This project is MIT licensed.