SQL Zoo

Solutions to SqlZoo.

Useful Resources

Stack Overflow - round numbers to nearest 1000
DataCamp - sql like pattern matching
FreeCodeCamp - sql contains string sql regex examples
Tech on the net - where clause
Stack Overflow - exclude statement in sql
Educba - sql exclude
Stack Overflow - umlaut
Stack Overflow - apostrophe
Mode - sql joins where vs on
Stack Overflow - multiple group by in sql
Stack Overflow - specify condition in count?
Stack Overflow - select query with case condition and sum function
Stack Overflow - join #13
Learn SQL - join 3 or more tables
SQL Shack - sql rank functions
YouTube - partition by
Stack Overflow - window #5
SQL Tutorial - sql window functions
W3 Resource - self join
W3 Schools - having
Learn SQL - join same table twice
Stack Overflow - self-join #10
Reddit - self-join #10
Stack Overflow - select-select #10
Stack Overflow - music #8
YouTube - SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial
Stack Overflow - covid #7
Stack Overflow - covid #8
Stack Overflow - covid #8
Covid Tutorial - covid #8

Name		Name	Last commit message	Last commit date
Latest commit History 8 Commits
Covid.sql		Covid.sql
Join.sql		Join.sql
More-Join.sql		More-Join.sql
Music.sql		Music.sql
NSS.sql		NSS.sql
Nobel-Prizes.sql		Nobel-Prizes.sql
Null.sql		Null.sql
README.md		README.md
Scottish-Parliament.sql		Scottish-Parliament.sql
Select-Basics.sql		Select-Basics.sql
Select-Nobel.sql		Select-Nobel.sql
Select-Select.sql		Select-Select.sql
Select-World.sql		Select-World.sql
Self-Join.sql		Self-Join.sql
Sum-and-Count.sql		Sum-and-Count.sql
Window.sql		Window.sql