Skip to content

This repository contains solutions to the SQL challenges posted on Data Lemur website using PostgreSQL environment

License

Notifications You must be signed in to change notification settings

nalliee/DataLemur-SQL-Challenges

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Solutions for SQL Challenges hosted on DataLemur

built_with_love powered_by_coffee

Overview Contents Support License

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 type of content present in the directories is as follows:

  • Easy
  • Medium
  • Hard

This directory contains the solution pgSQL scripts for the challenges mentioned in the Solution Scripts table.

Contents

The solutions are provided in the following formats:

  • Solution Scripts

Solution Scripts

In the below table, the columns indicate the following attributes related to the weekly challenge:

  • No : number of column for individual challenge
  • Challenge : Link to the SQL challenge hosted on DataLemur
  • Solution Scripts : Link to the solution SQL script hosted in this repository

Difficulty Level : Easy

No Challenge Solution Script
01 Histogram of Tweets Solution
02 Data Science Skills Solution
03 Page With No Likes Solution
04 Unfinished Parts Solution
05 Laptop vs. Mobile Viewership Solution
06 Average Post Hiatus (Part 1) Solution
07 Teams Power Users Solution
08 Duplicate Job Listings Solution
09 Cities With Completed Trades Solution
10 Average Review Ratings Solution
11 Well Paid Employees Solution
12 Final Account Balance Solution
13 QuickBooks vs TurboTax Solution
14 App Click-through Rate (CTR) Solution
15 Second Day Confirmation Solution
16 IBM db2 Product Analytics Solution
17 Cards Issued Difference Solution
18 Compressed Mean Solution
19 Pharmacy Analytics (Part 1) Solution
20 Pharmacy Analytics (Part 2) Solution
21 Pharmacy Analytics (Part 3) Solution
22 Patient Support Analysis (Part 1) Solution
23 Most Expensive Purchase Solution
24 ApplePay Volume Solution
25 Subject Matter Experts Solution
26 LinkedIn Power Creators (Part 1) Solution
27 Highest Number of Products Solution
28 Spare Server Capacity Solution
29 Top Rated Businesses Solution
30 Ad Campaign ROAS Solution
31 Product Line Revenue Solution
32 Trade In Payouts Solution
33 Webinar Popularity Solution
34 Who Made Quota? Solution

Difficulty Level : Medium

No Challenge Solution Script
01 User's Third Transaction Solution
02 Second Highest Salary Solution
03 Sending vs. Opening Snaps Solution
04 Tweets' Rolling Averages Solution
05 Highest-Grossing Items Solution
06 Top Three Salaries Solution
07 Signup Activation Rate Solution
08 Fill Missing Client Data Solution
09 Spotify Streaming History Solution
10 Mean, Median, Mode Solution
11 Pharmacy Analytics (Part 4) Solution
12 Frequently Purchased Pairs Solution
13 Supercloud Customer Solution
14 Odd and Even Measurements Solution
15 Swapped Food Delivery Solution
16 FAANG Stock Min-Max (Part 1) Solution
17 Booking Referral Source Solution
18 User Shopping Sprees Solution
19 2nd Ride Delay Solution
20 Histogram of Users and Purchases Solution
21 Google Maps Flagged UGC Solution
22 Compressed Mode Solution
23 Card Launch Success Solution
24 International Call Percentage Solution
25 Patient Support Analysis (Part 2) Solution
26 LinkedIn Power Creators (Part 2) Solution
27 Unique Money Transfer Relationships Solution
28 User Session Activity Solution
29 First Transaction Solution
30 Email Table Transformation Solution
31 Photoshop Revenue Analysis Solution
32 Consulting Bench Time Solution
33 Sales Team Compensation Solution
34 Average Deal Size (Part 2) Solution
35 Cumulative Purchases by Product Type Solution
36 Invalid Search Results Solution
37 Repeat Purchases on Multiple Days Solution
38 Compensation Outliers Solution
39 FAANG Stock Monthly Change (Part 2) Solution

Difficulty Level : Hard

No Challenge Solution Script
01 Active User Retention Solution
02 Y-on-Y Growth Rate Solution
03 Maximize Prime Item Inventory Solution
04 Median Google Search Frequency Solution
05 Advertiser Status Solution
06 Consecutive Filing Years Solution
07 Marketing Touch Streak Solution
08 3-Topping Pizzas Solution
09 Department vs. Company Salary Solution
10 Compressed Median Solution
11 Average Vacant Days Solution
12 Patient Support Analysis (Part 3) Solution
13 Patient Support Analysis (Part 4) Solution
14 Same Week Purchases Solution
15 Follow-Up Airpod Percentage Solution
16 Repeated Payments Solution
17 FAANG Underperforming Stocks (Part 3) Solution
18 User Concurrent Sessions Solution
19 Monthly Merchant Balance Solution
20 Bad Delivery Rate Solution
21 Page Recommendation Solution
22 Reactivated Users Solution
23 Senior Managers Solution
24 Event Friends Recommendation Solution
25 Matching Rental Amenities Solution
26 Weekly Churn Rates Solution
27 Uniquely Staffed Consultants Solution
28 Server Utilization Time Solution

Support

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

Linkedin Natasha Lie

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.

About

This repository contains solutions to the SQL challenges posted on Data Lemur website using PostgreSQL environment

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published