The compiled solutions encompass all SQL questions, ranging from Medium to Very Hard (excluded Easy), on NamasteSQL by Ankit Bansal. These solutions were executed on the integrated PostgreSQL environment.
NOTE: Currently consists of only the Free Questions.
In the below tables, the columns indicate the following attributes related to the weekly challenge:
-
ID : Identity column for individual challenge
-
Challenge : Link to the SQL challenge hosted on NamasteSQL by Ankit Bnsal
-
Solution Script : Link to the solution SQL script hosted in this repository.
| ID | Challenge | Solution |
|---|---|---|
| 01 | 7 - Airbnb Top Hosts | Solution |
| 02 | 26 - Dynamic Pricing | Solution |
| 03 | 52 - Loan Repayment | Solution |
| 04 | 55 - Lowest Price | Solution |
| 05 | 64 - Penultimate Order | Solution |
| ID | Challenge | Solution |
|---|---|---|
| 01 | 15 - Lift Overloaded - Part 1 | Solution |
| 02 | 76 - Amazon Notifications | Solution |
| 03 | 118 - User Session Actibity | 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 !!