SQLZOO Solutions

Solution of the questions available on https://sqlzoo.net/

Content

• Disclaimer
• Solutions Index

Disclaimer

The sole purpose of this repository is learning.

The real world data comes from some data source and the best way of fetching the data is using SQL queries. You are not lucky everytime to have your data coming in CSV or some flat files.

The work on this repo was started during Christmas 🎄 holidays and is really close to my ❤️

Note: If you find any discrepancy in the SQL queries for any question feel free 🙂 to raise an issue.

Solutions Index

• 0 SELECT basics

• 1 SELECT name

• 2 SELECT from World

• 3 SELECT from Nobel

• 4 SELECT within SELECT

• 5 SUM and COUNT

• 6 JOIN

• 7 More JOIN operations

• 8 Using Null

• 8+ Numeric Examples

• 9- Window function