The compiled solutions encompass all SQL challenges, ranging from Easy to Hard, on InterviewBit. These solutions were executed in a MySQL environment.
In the below tables, the columns indicate the following attributes related to the weekly challenge:
-
ID : Identity column for individual challenge.
-
Challenges : Link to the SQL questions hosted on InterviewBit.
-
Difficulty : Difficulty level of the SQL challenge.
-
Solution Script : Link to the solution SQL script hosted in this repository.
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Town Selection | 🟢 | Solution |
| 2 | Town Queries | 🟢 | Solution |
| 3 | Student Query | 🟢 | Solution |
| 4 | Country Filtration | 🟢 | Solution |
| 5 | Information Selector | 🟢 | Solution |
| 6 | Town of Threes | 🟢 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Conditional Work | 🟡 | Solution |
| 2 | Role Ordering | 🔴 | Solution |
| 3 | Role Player | 🔴 | Solution |
| 4 | Role Counter | 🟡 | Solution |
| 5 | Vowel Country | 🟡 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Firefighter's Average | 🟢 | Solution |
| 2 | Firefighter's Sum | 🟢 | Solution |
| 3 | Largest Difference | 🟢 | Solution |
| 4 | Distance Maximizer | 🟡 | Solution |
| 5 | Euclid's Distance | 🟡 | Solution |
| 6 | Big Salary | 🟡 | Solution |
| 7 | 5th Highest Marks | 🟡 | Solution |
| 8 | Famous Books | 🔴 | Solution |
| 9 | Chess Tournament | 🔴 | Solution |
| 10 | NULL sorting | 🔴 | Solution |
| 11 | I hate Vowels | 🔴 | Solution |
| 12 | Birthdays | 🔴 | Solution |
| 13 | Class Average | 🔴 | Solution |
| 14 | Tournament 2.0 | 🔴 | Solution |
| 15 | Job Offer | 🔴 | Solution |
| 16 | Next & Previous | 🔴 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Engineers Joined | 🟢 | Solution |
| 2 | Many Tables | 🟢 | Solution |
| 3 | Top Performer | 🔴 | Solution |
| 4 | Low and High Grades | 🟡 | Solution |
| 5 | Same Countries | 🟡 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Perfromance Improvement | 🟡 | Solution |
| 2 | Student Info | 🟡 | Solution |
| 3 | Minimum GPA | 🔴 | Solution |
| 4 | Number of Offers | 🔴 | Solution |
| 5 | Neutral Reviewers | 🟢 | Solution |
| 6 | Movie Character | 🟡 | Solution |
| 7 | Short Films | 🟡 | Solution |
| ID | Challenges | Difficulty | Solutions |
|---|---|---|---|
| 1 | Study Selection | 🟡 | Solution |
| 2 | Study Update | 🟡 | Solution |
| 3 | Study Deletion | 🟡 | Solution |
| 4 | Job Offers 2.0 | 🔴 | Solution |
| 5 | Actors and their Movies | 🟡 | Solution |
Contributions are always welcome !!
If you would like to contribute to the project, please fork the repository and make a pull request.
If you have any doubts, queries or, suggestions then, please connect with me on LinkedIn.
Do ⭐ the repository, if it inspired you, gave you ideas of your own or helped you in any way !!