/DateLemur-SQL-Interview-Questions

My solutions for #Datalemur SQL Interview Questions

OtherNOASSERTION

Project Logo


Solutions for SQL Challenges hosted on DataLemur

OverviewContents

🔎Overview

This repository contains my solutions for the SQL challenges posted on DataLemur website. The solution queries are executed on the integrated PostgreSQL environment on the same website.

🎯Content

The repository directory structure is as follows:

DataLemur-SQL-Challenges:

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

In the below table, the columns indicate the following attributes related to the 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 Teams Power Users Solution
05 Highest Number of Products Solution
06 Histogram of Tweets Solution
07 Spare Server Capacity Solution
08 Duplicate Job Listings Solution
09 Average Post Hiatus (Part 1) Solution
10 App Clickthrough Rate (CTR) Solution
11 LinkedIn Power Creators (Part 1) Solution
12 Data Science Skills Solution
13 Final Account Balance Solution
14 Average Review Ratings Solution
15 Unfinished Parts Solution
16 Ad Campaign ROAS Solution
17 Second Day Confirmation Solution
18 Apple Pay Volume Solution
19 Average Deal Size (Part 1) Solution
20 Top Rated Businesses Solution
21 Patient Support Analysis (Part 1) Solution
22 Pharmacy Analytics (Part 2) Solution
23 Pharmacy Analytics (Part 3) Solution
24 Cards Issued Difference Solution
25 Compressed Mean Solution

Difficulty Level: Medium

ID Challenge Solution Script
01 User's Third Transaction Solution
02 Compensation Outliers Solution
03 Sending vs. Opening Snaps Solution
04 Tweets' Rolling Averages Solution
05 Odd and Even Measurements Solution
06 Highest-Grossing Items Solution
07 First Transaction Solution
08 Top 5 Artists Solution
09 Signup Confirmation Rate Solution
10 Supercloud Customer Solution
11 Histogram of Users and Purchases Solution
12 Card Launch Success Solution
13 Compressed Mode Solution
14 International Call Percentage Solution
15 Best-Selling Product Solution
16 NYC Area Code Solution

Difficulty Level: Hard

ID Challenge Solution Script
01 Active User Retention Solution
02 Y-on-Y Growth Rate Solution
03 Advertiser Status Solution
04 Median Google Search Frequency Solution