HackerRank Medium SQL Challenges

Below are my solutions to all Medium SQL challenges on HackerRank.

---

1) The PADS

Question

Solution

MySQL / MS SQL Server

Output

---

2) Occupations

Question

Solution

MS SQL Server

MySQL

Output

---

3) Binary Tree Nodes

Question

Solution

MySQL / MS SQL Server / Oracle / DB2

Output

---

4) New Companies

Question

Solution

MySQL / MS SQL Server / Oracle / DB2

Output

---

5) Weather Observation Station 18

Question

Solution

MySQL / Oracle

Output

---

6) Weather Observation Station 19

Question

Solution

MySQL / Oracle

Output

---

7) Weather Observation Station 20

Question

Solution

MySQL / Oracle

Output

---

8) The Report

Question

Solution

MySQL

Output

---

9) Top Competitors

Question

Solution

MySQL / MS SQL Server / Oracle / DB2

Output

---

10) Ollivander's Inventory

Question

Solution

MS SQL Server / DB2

Output

---

11) Challenges

Question

Solution

MS SQL Server / DB2

Output

---

12) Contest Leaderboard

Question

Solution

MS SQL Server

Output

---

13) SQL Project Planning

Question

Solution

MS SQL Server

Output

---

14) Placements

Question

Solution

MySQL / MS SQL Server / DB2 / Oracle

Output

---

15) Symmetric Pairs

Question

Solution

MySQL / MS SQL Server / Oracle / DB2

Output

---

16) Print Prime Numbers

Question

Solution

MS SQL Server

Output

! jupyter nbconvert --to html HackerRank_Medium_SQL_Challenges_Screenshots.ipynb

[NbConvertApp] Converting notebook HackerRank_Medium_SQL_Challenges_Screenshots.ipynb to html
[NbConvertApp] Writing 12788484 bytes to HackerRank_Medium_SQL_Challenges_Screenshots.html