This repository contains SQL queries from various popular online learning resources e.g. SQLZoo, Vertabelo Academy etc.
| Topics | # Total Problem | # of Solved |
|---|---|---|
| 0 SELECT basics | 03 | 03 |
| 1 SELECT name | 15 | 15 |
| 2 SELECT from World | 13 | 13 |
| 3 SELECT from Nobel | 14 | 14 |
| 4 SELECT within SELECT | 10 | 10 |
| 5 SUM and COUNT | 08 | 08 |
| 6 JOIN | 13 | 13 |
| 7 More JOIN operations | 15 | 15 |
| 8 Using Null | 10 | 10 |
| 8+ Numeric Examples | 08 | 08 |
| 9 Self join | 10 | 09 |
| Topics | # Total Problem (Free) | # of Solved |
|---|---|---|
| 1_Select From Table Section | 06 | 06 |
| 2_Aggregation and grouping | 08 | 08 |
| 3_SQL Join Types | 16 | 16 |
0 SELECT basics section:
| Problem Statement + MySQL Solution |
|---|
| Introducing the world table of countries |
| Scandinavia |
| Just the right size |
1 SELECT name section:
| Problem Statement + MySQL Solution |
|---|
| Problem 1 |
| Problem 2 |
| Problem 3 |
| Problem 4 |
| Problem 5 |
| Problem 6 |
| Problem 7 |
| Problem 8 |
| Problem 9 |
| Problem 10 |
| Problem 11 |
| Problem 12 |
| Problem 13 |
| Problem 14 |
| Problem 15 |
2_Select from world section:
3_SELECT from Nobel section:
4_SELECT within SELECT section:
6_Join Operations section:
7_More Join Operation section:
8_Using Null section:
8+_Numeric Example section:
9_Self Join section:
1_Select From Table Section section:
| Problem Statement + MySQL Solution |
|---|
| Kittens |
| Young and old ragdoll cats |
| Which cats like to play with balls |
| The most bored cat |
| Elder cats have some fun |
| Adult cat that love teaser toys |