Skip to content

smeetpatel2530/Striver-SQL-Leetcode-Problems

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

71 Commits
 
 
 
 

Repository files navigation

Striver SQL LeetCode Problems

SQL LeetCode Tracker Badge Focus SQL Practice Badge Level Badge

A well-structured repository to track SQL problem solving, solution organization, and direct mapping between curated problem names and official LeetCode problem links. This repository is designed for systematic SQL interview preparation with clean folder structure, readable solutions, and easy navigation.

Repository Purpose

This repository helps organize SQL practice in a portfolio-friendly format by connecting each curated problem label to its official LeetCode page and linking each listed problem name to a local solution file inside the repository.

SQL Problem Map

Click the Problem Name to open the local SQL solution file in the repository.
Click the LeetCode Link to open the official problem statement.

Sr. No. Problem Name LeetCode Link
1 Large Nations Big Countries
2 Profitable Customers in 2021 Find Customers With Positive Revenue This Year
3 Odd Non-Boring Movies Not Boring Movies
4 Filter Records Excluding a Specific Pattern Link to be added
5 Find Records Excluding a Given Set of Values Link to be added
6 Find Salaries Outside the Expected Range Link to be added
7 Non-Referred Customers Find Customer Referee
8 First Login Analysis Game Play Analysis I
9 Employee Work Time Summary Find Total Time Spent by Each Employee
10 Unique Subjects per Teacher Number of Unique Subjects Taught by Each Teacher
11 User Follower Count Find Followers Count
12 CRM Automotive Sales Analysis Daily Leads and Partners
13 Highest Order Placing Customer Customer Placing the Largest Number of Orders
14 Frequent Actor-Director Duos Actors and Directors Who Cooperated At Least Three Times
15 Large Classes Classes With at Least 5 Students
16 Email Duplicates Duplicate Emails
17 Call Count Between Pairs Number of Calls Between Two Persons
18 Valid Triangle Check Triangle Judgement
19 Instant Food Delivery Immediate Food Delivery I
20 Special Bonus Calculation Calculate Special Bonus
21 Node Classification Tree Node
22 Apples vs Oranges Apples & Oranges
23 Query Quality Analysis Queries Quality and Percentage
24 Exceeding Tweet Length Invalid Tweets
25 System Settings Link to be added
26 Employee Salary Swap Salary
27 Combine Active and Archived Users Active Users
28 Merge Recent Orders from Multiple Sources Link to be added
29 Combine Sales Records Without Deduplication Link to be added
30 Reshape Products Data Rearrange Products Table
31 Employees and Their Departments Link to be added
32 Customer Orders Overview Link to be added
33 Employees With Confirmed Salary Records Link to be added
34 Generate All Possible User-Category Pairs Link to be added
35 Employees With or Without Salary Records Link to be added
36 Match Employees With Their Salaries Link to be added
37 Employees Earning More Than Their Manager Employees Earning More Than Their Managers
38 Students Enrolled in Courses Students with Invalid Departments
39 Sales Analysis Product Sales Analysis I
40 Minimum Distance Between Points Shortest Distance in a Line
41 Suspended Accounts Leetflex Banned Accounts
42 Find Team Size for Each Employee Find the Team Size
43 Average Experience by Project Project Employees I
44 Warehouse Stock Manager Warehouse Manager
45 Table Join Operation Link to be added
46 Inactive Customers Active Users
47 Students Enrolled in Non-Existent Departments Link to be added
48 Low Bonus Employees Employee Bonus
49 Available Seat Streaks Available Seats
50 Visitors Without Transactions Customer Who Visited but Did Not Make Any Transactions
51 A & B Buyers Without C Link to be added
52 Product Selling Price Report Average Selling Price
53 Updated Bank Balances Bank Account Summary II
54 Most Frequent Travellers Top Travellers
55 Suggested Pages Page Recommendation II
56 Contest Participation Rate Percentage of Users Attended a Contest
57 High-Report Managers Managers with at Least 5 Direct Reports
58 All-Product Buyers Customers Who Bought All Products
59 Highest Non-Repeating Number Biggest Single Number
60 Find the First Device Logged In by Each Player Game Play Analysis I
61 Salespersons Without RED Orders Sales Person
62 Employees with the Highest Salary in Each Department Department Highest Salary
63 Find the Most Recent Order for Each Product The Most Recent Orders For Each Product
64 Find Transactions with Maximum Amount Per Day Maximum Transaction Each Day
65 Incomplete Employee Records Employees With Missing Information
66 Find Quiet Students in All Exams Find The Quiet Students In All Exams
67 Top Grade per Student Highest Grade For Each Student
68 Swap Consecutive Seats Exchange Seats
69 Safe Investment Countries Countries You Can Safely Invest In
70 Tennis Grand Slam Winners Grand Slam Titles
71 Football Team Scores Team Scores In Football Tournament
72 Order Count per Customer Customer Order Frequency
73 Boolean Expression Evaluator Evaluate Boolean Expression
74 Immediate First Orders Percentage Immediate Food Delivery II
75 Find All Employees Reporting to the Head of the Company All People Report To The Given Manager
76 Orphan Employees Employees Whose Manager Left the Company
77 Most Frequently Ordered Product(s) for Each Customer Most Frequently Ordered Product for Each Customer
78 Find Missing Subtasks for Each Task Find the Subtasks That Did Not Execute
79 Latest 2020 Login The Latest Login in 2020
80 Kid-Friendly Movies in Last Month Link to be added
81 Warmer Days Rising Temperature
82 Restaurant Payment Trends Restaurant Growth
83 Inactive Sellers Sellers With No Sales

Releases

No releases published

Packages

 
 
 

Contributors