/Leetcode_Database_Problems

Solutions to Database Questions on Leetcode

Leetcode_Database_Problems

Solutions to Database Questions on Leetcode


Easy Level


S. NO. ID Question Link
1 1757 Recyclable and Low Fat Products here
2 1741 Find Total Time Spent by Each Employee here
3 1693 Daily Leads and Partners here
4 1873 Calculate Special Bonus here
5 1683 Invalid Tweets here
6 1378 Replace Employee ID With The Unique Identifier here
7 1303 Find the Team Size here
8 1350 Students With Invalid Departments here
9 1795 Rearrange Products Table here
10 1587 Bank Account Summary II here
11 1821 Find Customers With Positive Revenue this Year here
12 1581 Customer Who Visited but Did Not Make Any Transactions here
13 1571 Warehouse Manager here



Medium Level


S. NO. ID Question Link
1 1445 Apples & Oranges here
2 1393 Capital Gain/Loss here
3 2084 Drop Type 1 Orders for Customers With Type 0 Orders here
4 1783 Grand Slam Titles here
5 1285 Find the Start and End Number of Continuous Ranges here
6 1308 Running Total for Different Genders here
7 1270 All People Report to the Given Manager here
8 1699 Number of Calls Between Two Persons here
9 2066 Account Balance here
10 1596 The Most Frequently Ordered Products for Each Customer here
11 1831 Maximum Transaction Each Day here
12 1468 Calculate Salaries here
13 534 Game Play Analysis III here
14 1398 Customers Who Bought Products A and B but Not C here
15 1364 Number of Trusted Contacts of a Customer here
16 1077 Project Employees III here
17 1709 Biggest Window Between Visits here
18 1715 Count Apples and Oranges here
19 1934 Confirmation Rate here
20 2041 Accepted Candidates From the Interviews here
21 1867 Orders With Maximum Quantity Above Average here
22 1613 Find the Missing IDs here
23 1440 Evaluate Boolean Expression here
24 1875 Group Employees of the Same Salary here
25 1355 Activity Participants here
26 1204 Last Person to Fit in the Elevator here
27 1112 Highest Grade For Each Student here
28 2051 The Category of Each Member in the Store here
29 1321 Restaurant Growth here
30 2020 Number of Accounts That Did Not Stream here
31 1951 All the Pairs With the Maximum Number of Common Followers here
32 608 Tree Node here
33 1532 The Most Recent Three Orders here
34 1988 Find Cutoff Score for Each School here
35 626 Exchange Seats here
36 2112 The Airport With the Most Traffic here
37 1459 Rectangles Area here
38 1164 Product Price at a Given Date here
39 1126 Active Businesses here
40 1549 The Most Recent Orders for Each Product here
41 1264 Page Recommendations here
42 1747 Leetflex Banned Accounts here
43 1193 Monthly Transactions I here
44 1045 Customers Who Bought All Products here
45 570 Managers with at Least 5 Direct Reports here
46 1907 Count Salary Categories here
47 1158 Market Analysis I here
48 2175 The Change in Global Rankings here
49 1811 Find Interview Candidates here
50 1174 Immediate Food Delivery II here
51 2159 Order Two Columns Independently here
52 612 Shortest Distance in a Plane here
53 602 Friend Requests II: Who Has the Most Friends here
54 1949 Strong Friendship here
55 574 Winning Candidate here
56 1341 Movie Rating here
57 178 Rank Scores here
58 1501 Countries You Can Safely Invest In here
59 580 Count Student Number in Departments here
60 1212 Team Scores in Football Tournament here
61 1841 League Statistics here
62 585 Investments in 2016 here
63 1555 Bank Account Summary here
64 1990 Count the Number of Experiments
65 2142 The Number of Passengers in Each Bus I
66 1070 Product Sales Analysis III
67 184 Department Highest Salary
68 1843 Suspicious Bank Accounts
69 1149 Article Views II
70 180 Consecutive Numbers
71 1107 New Users Daily Count
72 1098 Unpopular Books
73 2228 Users With Two Purchases Within Seven Days
74 550 Game Play Analysis IV
75 1205 Monthly Transactions II
76 578 Get Highest Answer Rate Question
77 2292 Products With Three or More Orders in Two Consecutive Years
78 1454 Active Users
79 177 Nth Highest Salary
80 614 Second Degree Follower
81 176 Second Highest Salary
82 2346 Compute the Rank as a Percentage
83 1132 Reported Posts II
84 2372 Calculate the Influence of Each Salesperson
85 2388 Change Null Values in a Table to the Previous Value
86 2298 Tasks Count in the Weekend
87 2324 Product Sales Analysis IV
88 2308 Arrange Table by Gender
89 2314 The First Day of the Maximum Recorded Degree in Each City
90 2238 Number of Times a Driver Was a Passenger
91 2394 Employees With Deductions



Hard Level


S. NO. ID Question Link
1 2362 Generate the Invoice here