This repository contains solutions to daily SQL, Pandas, and PySpark problems from various online problem-solving platforms. The solutions are organized by platform name, technology, and functions used to solve the problem.
The motivation behind this repository is to improve problem-solving skills and gain practical experience with SQL, Pandas, and PySpark. By solving a diverse range of problems on a daily basis, we can sharpen our analytical thinking, learn new techniques, and stay up-to-date with the latest developments in these domains.
One problem a day keep the imposter syndrome away
| Platform | Technology | Solutions | Tags |
|---|---|---|---|
| DataLemur | sql | Active User Retention | WITH, LAG, EXTRACT, date_trunc, interval, count, distinct, GROUP BY |
| Y-on-Y Growth Rate | CTE, LAG, OVER, PARTITION BY, ORDER BY, EXTRACT, ROUND, CASE | ||
| LeetCode | pandas | Exchange Seats | SIZE, COPY, SHIFT, LOC, FILLNA, ILOC |
| Friend Requests II Who Has the Most Friends | RENAME, GROUP BY, COUNT, CONCAT, SORT, HEAD | ||
| Movie Rating | JOIN, GROUP BY, COUNT, SORT VALUES, QUERY, MEAN | ||
| Rank Scores | SORT VALUES, DENSE RANK | ||
| sql | Customers Who Bought All Products | GROUP BY, HAVING, COUNT, DISTINCT | |
| Department Highest Salary | RANK, WHERE, WITH, SELECT, FROM, ORDER BY, PARTITION BY | ||
| Department Top Three Salaries | DENSE RANK, PARTITION BY, ORDER BY, DESC, JOIN, WHERE | ||
| Exchange Seats | CASE, WHEN, LAG, LEAD, IS NOT NULL, WINDOW FUNCTION | ||
| Friend Requests II Who Has the Most Friends | CTE, UNION ALL, GROUP BY, ORDER BY, LIMIT, COUNT, DESC | ||
| Human Traffic of Stadium | CTE, ROW_NUMBER, GROUP BY, HAVING, WHERE, IN, COUNT, WINDOW FUNCTION | ||
| Product Sales Analysis III | CTE, RANK, JOIN, WHERE | ||
| StrataScratch | pandas | Risky Projects | TOTAL SECONDS, JOIN, GROUP BY, SUM, ASTYPE |
| pyspark | Most Profitable Companies | DENSE RANK, ORDER BY, GROUP BY, SUM, WHERE, SELECT | |
| Population Density | ROUND, CAST, MAX, MIN, WHERE, COLLECT | ||
| Population Density | DENSE RANK, ORDER BY, ROUND, CAST, WHERE | ||
| Workers With The Highest Salaries | ORDER BY, WHERE, INNER JOIN, DISTINCT, RANK | ||
| sql | Activity Rank | CTE, ROW NUMBER, ORDER BY, GROUP BY, COUNT, DESCs | |
| Most Profitable Companies | ORDER BY, LIMIT | ||
| Population Density | CTE, CASE, FLOOR, ORDER BY | ||
| Population Density | RANK, ORDER BY, NULLIF | ||
| Users by Average Session Time | CTE, CASE, DATE, GROUP BY, HAVING |