Overview • Contents • Support • License
This repository contains solution for the SQL challenges posted on DataLemur website. The solution queries are executed on the integrated PostgreSQL environment on the same website.
The repository directory structure is as follows:
DataLemur-SQL-Challenges
├─ 01_SCRIPTS
├─ 02_NOTEBOOKS
├─ 03_RESOURCES
The type of content present in the directories is as follows:
01_SCRIPTS
This directory contains the solution pgSQL scripts for the challenges mentioned in the Solution Scripts table.
02_NOTEBOOKS
This directory contains the solution pgSQL notebooks for the challenges for distinct difficulty levels
03_RESOURCES
This directory contains images, icons, layouts, etc. that are used in this repository.
The SQL flavor used in the solution queries is pgSQL
The solutions are provided in the following formats:
- Solution Scripts
- Solution Notebooks
The Solution Notebooks and one stop shop for the SQL challenges of distinct difficulty level whereas the Solution Scripts are nothing but, individual SQL solution queries for individual problem.
The difficulty group tagging of a question might change in future by the author of website however, that doesn't affect the solution anyway as the question still remains the same.
The two different formats are made for ease of accessibility purpose only. The overall contents of Solution Notebooks and Solution Scripts are same.
In the below table, 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 DataLemur
- Solution Script : Link to the solution SQL script hosted in this repository
| ID | Challenge | Solution Script |
|---|---|---|
| 01 | Active User Retention | Solution |
| 02 | Y-on-Y Growth Rate | Solution |
| 03 | User Shopping Sprees | Solution |
| 04 | Monthly Merchant Balance | Solution |
| 05 | Bad Delivery Rate | Solution |
| 06 | Solution |
The following notebooks contains the solution along with some explanations (if required) for SQL challenges of distinct difficulty level.
If you have any doubts, queries or, suggestions then, please connect with me in any of the following platforms:
If you like my work then, you may Buy me a coffee
Get access to bonus content and exclusive prizes for both of us by signing-up, followed by email verification using this link
This license allows reusers to distribute, remix, adapt, and build upon the material in any medium or format for noncommercial purposes only, and only so long as attribution is given to the creator. If you remix, adapt, or build upon the material, you must license the modified material under identical terms.