HackerRank Hard SQL Challenges

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

1) Interviews

Question

Screen Shot 2021-01-13 at 6.01.40 PM.png

Screen Shot 2021-01-13 at 6.03.02 PM.png

Screen Shot 2021-01-13 at 6.03.37 PM.png

Solution

MS SQL Server / DB2

Screen%20Shot%202021-01-13%20at%2011.39.11%20PM.png

Output

Screen%20Shot%202021-01-16%20at%206.54.34%20PM.png

2) 15 Days of Learning SQL

Question

Screen Shot 2021-01-13 at 7.07.35 PM.png

Screen Shot 2021-01-13 at 7.10.40 PM.png

Screen Shot 2021-01-13 at 7.11.28 PM.png

Solution

MySQL

Screen%20Shot%202021-01-13%20at%2011.41.41%20PM.png

Output

Screen%20Shot%202021-01-16%20at%206.56.33%20PM.png

In [1]:
! jupyter nbconvert --to html HackerRank_Hard_SQL_Challenges_Screenshots.ipynb

[NbConvertApp] Converting notebook HackerRank_Hard_SQL_Challenges_Screenshots.ipynb to html
[NbConvertApp] Writing 3056482 bytes to HackerRank_Hard_SQL_Challenges_Screenshots.html