LeetCode-SQL-PySpark-Solutions

KO | EN

gitlite — search

#javascript #llm #golang #go #rust #deep-learning #macos #java #nodejs #awesome #kubernetes #mcp #ios #open-source

LeetCode-SQL-PySpark-Solutions

(★ 34)

This repository contains my solutions to the top 50 LeetCode SQL challenges implemented using PySpark DataFrame and PySpark SQL.

LeetCode-SQL-PySpark-Solutions Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# LeetCode-SQL-PySpark-Solutions

This repository contains my solutions to the [top 50 LeetCode SQL challenges](https://leetcode.com/studyplan/top-sql-50/) implemented using Apache Spark DataFrame (PySpark) and Spark SQL.

I have used the provided pandas schema from the website and converted it into a Spark DataFrame before solving them. I employed Jupyter Notebooks for easy readability.

Each Jupyter Notebook contains both the problem statement and my solution. To practice, clone the repo and clear out the shells containing the solutions and write your own PySpark or Spark SQL code to solve the challenge.

## Table of Contents

### Select

1. [Recyclable and Low Fat Products](studyplan-top-sql-50/1_Select/01_1757_Recyclable_and_Low_Fat_Products.ipynb)
2. [Find Customer Referee](studyplan-top-sql-50/1_Select/02_584_Find_Customer_Referee.ipynb)
3. [Big Countries](studyplan-top-sql-50/1_Select/03_595_Big_Countries.ipynb)
4. [Article Views I](studyplan-top-sql-50/1_Select/04_1148_Article_Views_I.ipynb)
5. [Invalid Tweets](studyplan-top-sql-50/1_Select/05_1683_Invalid_Tweets.ipynb)

### Basic Joins

6. [Replace Employee ID With The Unique Identifier](studyplan-top-sql-50/2_Basic_Joins/06_1378_Replace_Employee_ID_With_The_Unique_Identifier.ipynb)
7. [Product Sales Analysis I](studyplan-top-sql-50/2_Basic_Joins/07_1068_Product_Sales_Analysis_I.ipynb)
8. [Customer Who Visited but Did Not Make Any Transactions](studyplan-top-sql-50/2_Basic_Joins/08_1581_Customer_Who_Visited_but_Did_Not_Make_Any_Transactions.ipynb)
9. [Rising Temperature](studyplan-top-sql-50/2_Basic_Joins/09_197_Rising_Temperature.ipynb)
10. [Average Time of Process per Machine](studyplan-top-sql-50/2_Basic_Joins/10_1661_Average_Time_of_Process_per_Machine.ipynb)
11. [Employee Bonus](studyplan-top-sql-50/2_Basic_Joins/11_577_Employee_Bonus.ipynb)
12. [Students and Examinations](studyplan-top-sql-50/2_Basic_Joins/12_1280_Students_and_Examinations.ipynb)
13. [Managers with at Least 5 Direct Reports](studyplan-top-sql-50/2_Basic_Joins/13_570_Managers_with_at_Least_5_Direct_Reports.ipynb)
14. [Confirmation Rate](studyplan-top-sql-50/2_Basic_Joins/14_1934_Confirmation_Rate.ipynb)

### Basic Aggregate Functions

15. [Not Boring Movies](studyplan-top-sql-50/3_Basic_Aggregate_Functions/15_620_Not_Boring_Movies.ipynb)
16. [Average Selling Price](studyplan-top-sql-50/3_Basic_Aggregate_Functions/16_1251_Average_Selling_Price.ipynb)
17. [Project Employees I](studyplan-top-sql-50/3_Basic_Aggregate_Functions/17_1075_Project_Employees_I.ipynb)
18. [Percentage of Users Attended a Contest](studyplan-top-sql-50/3_Basic_Aggregate_Functions/18_1633_Percentage_of_Users_Attended_a_Contest.ipynb)
19. [Queries Quality and Percentage](studyplan-top-sql-50/3_Basic_Aggregate_Functions/19_1211_Queries_Quality_and_Percentage.ipynb)
20. [Monthly Transactions I](studyplan-top-sql-50/3_Basic_Aggregate_Functions/20_1193_Monthly_Transactions_I.ipynb)
21. [Immediate Food Delivery II](studyplan-top-sql-50/3_Basic_Aggregate_Functions/21_1174_Immediate_Food_Delivery_II.ipynb)
22. [Game Play Analysis IV](studyplan-top-sql-50/3_Basic_Aggregate_Functions/22_550_Game_Play_Analysis_IV.ipynb)

### Sorting and Grouping

23. [Number of Unique Subjects Taught by Each Teacher](studyplan-top-sql-50/4_Sorting_and_Grouping/23_2356_Number_of_Unique_Subjects_Taught_by_Each_Teacher.ipynb)
24. [User Activity for the Past 30 Days I](studyplan-top-sql-50/4_Sorting_and_Grouping/24_1141_User_Activity_for_the_Past_30_Days_I.ipynb)
25. [Product Sales Analysis III](studyplan-top-sql-50/4_Sorting_and_Grouping/25_1070_Product_Sales_Analysis_III.ipynb)
26. [Classes More Than 5 Students](studyplan-top-sql-50/4_Sorting_and_Grouping/26_596_Classes_More_Than_5_Students.ipynb)
27. [Find Followers Count](studyplan-top-sql-50/4_Sorting_and_Grouping/27_1729_Find_Followers_Count.ipynb)
28. [Biggest Single Number](studyplan-top-sql-50/4_Sorting_and_Grouping/28_619_Biggest_Single_Number.ipynb)
29. [Customers Who Bought All Products](studyplan-top-sql-50/4_Sorting_and_Grouping/29_1045_Customers_Who_Bought_All_Products.ipynb)

### Advanced Select and Joins

30. [The Number of Employees Which Report to Each Employee](studyplan-top-sql-50/5_Advanced_Select_and_Joins/30_1731_The_Number_of_Employees_Which_Report_to_Each_Employee.ipynb)
31. [Primary Department for Each Employee](studyplan-top-sql-50/5_Advanced_Select_and_Joins/31_1789_Primary_Department_for_Each_Employee.ipynb)
32. [Triangle Judgement](studyplan-top-sql-50/5_Advanced_Select_and_Joins/32_610_Triangle_Judgement.ipynb)
33. [Consecutive Numbers](studyplan-top-sql-50/5_Advanced_Select_and_Joins/33_180_Consecutive_Numbers.ipynb)
34. [Product Price at a Given Date](studyplan-top-sql-50/5_Advanced_Select_and_Joins/34_1164_Product_Price_at_a_Given_Date.ipynb)
35. [Last Person to Fit in the Bus](studyplan-top-sql-50/5_Advanced_Select_and_Joins/35_1204_Last_Person_to_Fit_in_the_Bus.ipynb)
36. [Count Salary Categories](studyplan-top-sql-50/5_Advanced_Select_and_Joins/36_1907_Count_Salary_Categories.ipynb)

### Subqueries

37. [Employees Whose Manager Left the Company](studyplan-top-sql-50/6_Subqueries/37_1978_Employees_Whose_Manager_Left_the_Company.ipynb)
38. [Exchange Seats](studyplan-top-sql-50/6_Subqueries/38_626_Exchange_Seats.ipynb)
39. [Movie Rating](studyplan-top-sql-50/6_Subqueries/39_1341_Movie_Rating.ipynb)
40. [Restaurant Growth](studyplan-top-sql-50/6_Subqueries/40_1321_Restaurant_Growth.ipynb)
41. [Friend Requests II: Who Has the Most Friends](studyplan-top-sql-50/6_Subqueries/41_602_Friend_Requests_II_Who_Has_the_Most_Friends.ipynb)
42. [Investments in 2016](studyplan-top-sql-50/6_Subqueries/42_585_Investments_In_2016.ipynb)
43. [Department Top Three Salaries](studyplan-top-sql-50/6_Subqueries/43_185_Department_Top_Three_Salaries.ipynb)

### Advanced String Functions / Regex / Clause

44. [Fix Names in a Table](studyplan-top-sql-50/7_Advanced_String_Functions_Regex_Clause/44_1667_Fix_Names_in_a_Table.ipynb)
45. [Patients With a Condition](studyplan-top-sql-50/7_Advanced_String_Functions_Regex_Clause/45_1527_Patients_With_a_Condition.ipynb)
46. [Delete Duplicate Emails](studyplan-top-sql-50/7_Advanced_String_Functions_Regex_Clause/46_196_Delete_Duplicate_Emails.ipynb)
47. [Second Highest Salary](studyplan-top-sql-50/7_Advanced_String_Functions_Regex_Clause/47_176_Second_Highest_Salary.ipynb)
48. [Group Sold Products By The Date](studyplan-top-sql-50/7_Advanced_String_Functions_Regex_Clause/48_1484_Group_Sold_Products_By_The_Date.ipynb)
49. [List the Products Ordered in a Period](studyplan-top-sql-50/7_Advanced_String_Functions_Regex_Clause/49_1327_List_the_Products_Ordered_in_a_Period.ipynb)
50. [Find Users With Valid E-Mails](studyplan-top-sql-50/7_Advanced_String_Functions_Regex_Clause/50_1517_Find_Users_With_Valid_E-Mails.ipynb)

LeetCode-SQL-PySpark-Solutions

LeetCode-SQL-PySpark-Solutions Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

LeetCode-SQL-PySpark-Solutions

LeetCode-SQL-PySpark-Solutions Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README