Solutions for SQL Challenges hosted on DataLemur

Overview • Contents •

🔎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.sql>) | | 10 | App Clickthrough Rate (CTR) | Solution.sql>) | | 11 | LinkedIn Power Creators (Part 1) | Solution.sql>) | | 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.sql>) | | 20 | Top Rated Businesses | Solution | | 21 | Patient Support Analysis (Part 1) | Solution.sql>) | | 22 | Pharmacy Analytics (Part 2) | Solution.sql>) | | 23 | Pharmacy Analytics (Part 3) | Solution.sql>) | | 24 | Cards Issued Difference | Solution | | 25 | Compressed Mean | Solution | | 26 | Well Paid Employees | 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 | | 17 | Second Highest Salary |Solution | | 18 | Second Highest Salary |Solution | | 19 | Swapped Food Delivery |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 |