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