Skip to content

Latest commit

 

History

History
186 lines (131 loc) · 12.6 KB

readme.md

File metadata and controls

186 lines (131 loc) · 12.6 KB

Project Logo


Solutions for SQL Challenges hosted on DataLemur

built-with-love powered-by-coffee cc-nc-sa

OverviewContentsSupportLicense

Overview

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

Contents

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.

Solution Scripts

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

Difficulty Level : Easy

ID Challenge Solution Script
01 Cities With Completed Trades Solution
02 Page With No Likes Solution
03 Laptop vs Mobile Viewership Solution
04 Purchasing Activity by Product Type Solution
05 Teams Power Users Solution
06 Highest Number of Products Solution
07 Histogram of Tweets Solution
08 Spare Server Capacity Solution
09 Repeat Purchases on Multiple Days Solution
10 Duplicate Job Listings Solution
11 Average Post Hiatus (Part 1) Solution
12 App Clickthrough Rate (CTR) Solution
13 User's Third Transaction Solution
14 LinkedIn Power Creators (Part 1) Solution
15 Photoshop Revenue Analysis Solution
16 Data Science Skills Solution
17 Histogram of Users and Purchases Solution
18 Subject Matter Experts Solution
19 Final Account Balance Solution
20 Compensation Outliers Solution
21 Average Review Ratings Solution
22 Unfinished Parts Solution
23 Unique Money Transfer Relationships Solution
24 Ad Campaign ROAS Solution
25 Second Day Confirmation Solution
26 Apple Pay Volume Solution
27 Average Deal Size (Part 1) Solution

Difficulty Level : Medium

ID Challenge Solution Script
01 Sending vs. Opening Snaps Solution
02 Tweets' Rolling Averages Solution
03 Odd and Even Measurements Solution
04 Frequently Purchased Pairs Solution
05 Highest-Grossing Items Solution
06 First Transaction Solution
07 LinkedIn Power Creators (Part 2) Solution
08 Top 5 Artists Solution
09 Signup Confirmation Rate Solution
10 Consulting Bench Time Solution
11 Spotify Listening History Solution
12 Fill Missing Client Data Solution
13 User Session Activity Solution
14 Invalid Search Results Solution
15 Top Rated Businesses Solution
16 Same Week Purchases Solution

Difficulty Level : Hard

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

Solution Notebooks

The following notebooks contains the solution along with some explanations (if required) for SQL challenges of distinct difficulty level.

Support

If you have any doubts, queries or, suggestions then, please connect with me in any of the following platforms:

Linkedin Badge Twitter Badge

If you like my work then, you may Buy me a coffee

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

datalemur-referral-link

License

by-nc-sa

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.