Welcome to the Datalemuer SQL Solutions repository! This repository contains solutions to SQL questions found on the Datalemuer website. It aims to provide clear, well-documented, and efficient solutions for a wide range of SQL problems, from basic queries to more complex data manipulations.
Problem Name | Solution Link | Difficulty |
---|---|---|
App Click-through Rate (CTR) | App Click-through Rate (CTR).sql | ⭐⭐ |
Cities With Completed Trades | Cities With Completed Trades.sql | ⭐⭐ |
Compressed Mean | Compressed Mean.sql | ⭐⭐ |
Histogram of Tweets | Histogram of Tweets.sql | ⭐ |
Pharmacy Analytics (Part 2) | Pharmacy Analytics (Part 2).sql | ⭐ |
Pharmacy Analytics (Part 3) | Pharmacy Analytics (Part 3).sql | ⭐ |
Second Day Confirmation | Second Day Confirmation.sql | ⭐ |
TOP 5 Artist | TOP 5 Artist.sql | ⭐⭐ |
Tweets' Rolling Averages | Tweets' Rolling Averages.sql | ⭐⭐ |
User's Third Transaction | User's Third Transaction.sql | ⭐⭐ |
Activation Rate | Activation Rate.sql | ⭐ |
Data Science Skills | Data Science Skills.sql | ⭐ |
Odd vs Even | Odd vs Even.sql | ⭐ |
Pharmacy Analytics (Part 1) | Pharmacy Analytics 1.sql | ⭐ |
Histogram of Users and Purchases | Histogram of Users and Purchases.sql | ⭐⭐ |
FAANG Stock Min-Max (Part 1) | FAANG Stock Min-Max (Part 1).sql | ⭐⭐ |
3-Topping Pizzas | 3-Topping Pizzas.sql | ⭐⭐⭐ |
Compressed Mode | Compressed Mode.sql | ⭐⭐ |
International Call Percentage | International Call Percentage.sql | ⭐⭐ |
Card Launch Success | Card Launch Success.sql | ⭐⭐ |
Patient Support Analysis (Part 2) | Patient Support Analysis (Part 2) | ⭐⭐ |
Well Paid Employees | Well Paid Employees | ⭐ |
Odd and Even Measurements | Odd and Even Measurements | ⭐⭐⭐ |
Y-on-Y Growth Rate | Y-on-Y Growth Rate | ⭐⭐⭐ |
Repeated Payments | Repeated Payments | ⭐⭐⭐ |
Median Google Search Frequency | Median Google Search Frequency | ⭐⭐⭐ |
Maximize Prime Item Inventory | Maximize Prime Item Inventory | ⭐⭐⭐ |
Department vs. Company Salary | Department vs. Company Salary | ⭐⭐⭐ |
Server Utilization Time | Server Utilization Time | ⭐⭐⭐ |