Skip to content

MlvPrasadOfficial/LeetCode_SQL_Solutions_MLV_Prasad

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

36 Commits
 
 
 
 

Repository files navigation

Solutions will be posted by 15 july 2023

LeetCode SQL - MLV Prasad

Hi, I am MLV Prasad.

I am a Deep-Learning Enthusiast,I create content on Youtube on Various topics of Data Science.

This repository is an All in one Code Solution Repository of LEETCODE SQL QUESTIONS (220+) and video Explanations on my Channel here: Youtube

If you find this channel and this repository helpful, you can Support by subscribing to it...💫

S.No Ques.No Question Name Category Solution video Code
01 175 Combine Two Tables Easy - -
02 176 Second Highest Salary Medium - -
03 177 Nth Highest Salary Medium - -
04 178 Rank Scores Medium - -
05 180 Consecutive Numbers Medium - -
06 181 Employees Earning More Than Their Managers Easy - -
07 182 Duplicate Emails Easy - -
08 183 Customers Who Never Order Easy - -
09 184 Department Highest Salary Medium - -
10 185 Department Top Three Salaries Hard - -
11 196 Delete Duplicate Emails Easy - -
12 197 Rising Temperature Easy - -
13 262 Trips and Users Hard - -
14 511 Game Play Analysis I Easy - -
15 512 Game Play Analysis II Easy - -
16 534 Game Play Analysis III Medium - -
17 550 Game Play Analysis IV Medium - -
18 569 Median Employee Salary Hard - -
19 570 Managers with at Least 5 Direct Reports Medium - -
20 571 Find Median Given Frequency of Numbers Hard - -
21 574 Winning Candidate Medium - -
22 577 Employee Bonus Easy - -
23 578 Get Highest Answer Rate Question Medium - -
24 579 Find Cumulative Salary of an Employee Hard - -
25 580 Count Student Number in Departments Medium - -
26 584 Find Customer Referee Easy - -
27 585 Investments in 2016 Medium - -
28 586 Customer Placing the Largest Number of Orders Easy - -
29 595 Big Countries Easy - -
30 596 Classes More Than 5 Students Easy - -
31 597 Friend Requests I: Overall Acceptance Rate Easy - -
32 601 Human Traffic of Stadium Hard - -
33 602 Friend Requests II: Who Has the Most Friends Medium - -
34 603 Consecutive Available Seats Easy - -
35 607 Sales Person Easy - -
36 608 Tree Node Medium - -
37 610 Triangle Judgement Easy - -
38 612 Shortest Distance in a Plane Medium - -
39 613 Shortest Distance in a Line Easy - -
40 614 Second Degree Follower Medium - -
41 615 Average Salary: Departments VS Company Hard - -
42 618 Students Report By Geography Hard - -
43 619 Biggest Single Number Easy - -
44 620 Not Boring Movies Easy - -
45 626 Exchange Seats Medium - -
46 627 Swap Salary Easy - -
47 1045 Customers Who Bought All Products Medium - -
48 1050 Actors and Directors Who Cooperated At Least Three Times Easy - -
49 1068 Product Sales Analysis I Easy - -
50 1069 Product Sales Analysis II Easy - -
51 1070 Product Sales Analysis III Medium - -
52 1075 Project Employees I Easy - -
53 1076 Project Employees II Easy - -
54 1077 Project Employees III Medium - -
55 1082 Sales Analysis I Easy - -
56 1083 Sales Analysis II Easy - -
57 1084 Sales Analysis III Easy - -
58 1097 Game Play Analysis V Hard - -
59 1098 Unpopular Books Medium - -
60 1107 New Users Daily Count Medium - -
61 1112 Highest Grade For Each Student Medium - -
62 1113 Reported Posts Easy - -
63 1126 Active Businesses Medium - -
64 1127 User Purchase Platform Hard - -
65 1132 Reported Posts II Medium - -
66 1141 User Activity for the Past 30 Days I Easy - -
67 1142 User Activity for the Past 30 Days II Easy - -
68 1148 Article Views I Easy - -
69 1149 Article Views II Medium - -
70 1158 Market Analysis I Medium - -
71 1159 Market Analysis II Hard - -
72 1164 Product Price at a Given Date Medium - -
73 1173 Immediate Food Delivery I Easy - -
74 1174 Immediate Food Delivery II Medium - -
75 1179 Reformat Department Table Easy - -
76 1193 Monthly Transactions I Medium - -
77 1194 Tournament Winners Hard - -
78 1204 Last Person to Fit in the Bus Medium - -
79 1205 Monthly Transactions II Medium - -
80 1211 Queries Quality and Percentage Easy - -
81 1212 Team Scores in Football Tournament Medium - -
82 1225 Report Contiguous Dates Hard - -
83 1241 Number of Comments per Post Easy - -
84 1251 Average Selling Price Easy - -
85 1264 Page Recommendations Medium - -
86 1270 All People Report to the Given Manager Medium - -
87 1280 Students and Examinations Easy - -
88 1285 Find the Start and End Number of Continuous Ranges Medium - -
89 1294 Weather Type in Each Country Easy - -
90 1303 Find the Team Size Easy - -
91 1308 Running Total for Different Genders Medium - -
92 1321 Restaurant Growth Medium - -
93 1322 Ads Performance Easy - -
94 1327 List the Products Ordered in a Period Easy - -
95 1336 Number of Transactions per Visit Hard - -
96 1341 Movie Rating Medium - -
97 1350 Students With Invalid Departments Easy - -
98 1355 Activity Participants Medium - -
99 1364 Number of Trusted Contacts of a Customer Medium - -
100 1369 Get the Second Most Recent Activity Hard - -
101 1378 Replace Employee ID With The Unique Identifier Easy - -
102 1384 Total Sales Amount by Year Hard - -
103 1393 Capital Gain/Loss Medium - -
104 1398 Customers Who Bought Products A and B but Not C Medium - -
105 1407 Top Travellers Easy - -
106 1412 Find the Quiet Students in All Exams Hard - -
107 1421 NPV Queries Easy - -
108 1435 Create a Session Bar Chart Easy - -
109 1440 Evaluate Boolean Expression Medium - -
110 1445 Apples & Oranges Medium - -
111 1454 Active Users Medium - -
112 1459 Rectangles Area Medium - -
113 1468 Calculate Salaries Medium - -
114 1479 Sales by Day of the Week Hard - -
115 1484 Group Sold Products By The Date Easy - -
116 1495 Friendly Movies Streamed Last Month Easy - -
117 1501 Countries You Can Safely Invest In Medium - -
118 1511 Customer Order Frequency Easy - -
119 1517 Find Users With Valid E-Mails Easy - -
120 1527 Patients With a Condition Easy - -
121 1532 The Most Recent Three Orders Medium - -
122 1543 Fix Product Name Format Easy - -
123 1549 The Most Recent Orders for Each Product Medium - -
124 1555 Bank Account Summary Medium - -
125 1565 Unique Orders and Customers Per Month Easy - -
126 1571 Warehouse Manager Easy - -
127 1581 Customer Who Visited but Did Not Make Any Transactions Easy - -
128 1587 Bank Account Summary II Easy - -
129 1596 The Most Frequently Ordered Products for Each Customer Medium - -
130 1607 Sellers With No Sales Easy - -
131 1613 Find the Missing IDs Medium - -
132 1623 All Valid Triplets That Can Represent a Country Easy - -
133 1633 Percentage of Users Attended a Contest Easy - -
134 1635 Hopper Company Queries I Hard - -
135 1645 Hopper Company Queries II Hard - -
136 1651 Hopper Company Queries III Hard - -
137 1661 Average Time of Process per Machine Easy - -
138 1667 Fix Names in a Table Easy - -
139 1677 Product's Worth Over Invoices Easy - -
140 1683 Invalid Tweets Easy - -
141 1693 Daily Leads and Partners Easy - -
142 1699 Number of Calls Between Two Persons Medium - -
143 1709 Biggest Window Between Visits Medium - -
144 1715 Count Apples and Oranges Medium - -
145 1729 Find Followers Count Easy - -
146 1731 The Number of Employees Which Report to Each Employee Easy - -
147 1741 Find Total Time Spent by Each Employee Easy - -
148 1747 Leetflex Banned Accounts Medium - -
149 1757 Recyclable and Low Fat Products Easy - -
150 1767 Find the Subtasks That Did Not Execute Hard - -
151 1777 Product's Price for Each Store Easy - -
152 1783 Grand Slam Titles Medium - -
153 1789 Primary Department for Each Employee Easy - -
154 1795 Rearrange Products Table Easy - -
155 1809 Ad-Free Sessions Easy - -
156 1811 Find Interview Candidates Medium - -
157 1821 Find Customers With Positive Revenue this Year Easy - -
158 1831 Maximum Transaction Each Day Medium - -
159 1841 League Statistics Medium - -
160 1843 Suspicious Bank Accounts Medium - -
161 1853 Convert Date Format Easy - -
162 1867 Orders With Maximum Quantity Above Average Medium - -
163 1873 Calculate Special Bonus Easy - -
164 1875 Group Employees of the Same Salary Medium - -
165 1890 The Latest Login in 2020 Easy - -
166 1892 Page Recommendations II Hard - -
167 1907 Count Salary Categories Medium - -
168 1917 leetcodify Friends Recommendations Hard - -
169 1919 Leetcodify Similar Friends Hard - -
170 1934 Confirmation Rate Medium - -
171 1939 Users That Actively Request Confirmation Messages Easy - -
172 1949 Strong Friendship Medium - -
173 1951 All the Pairs With the Maximum Number of Common Followers Medium - -
174 1965 Employees With Missing Information Easy - -
175 1972 First and Last Call On the Same Day Hard - -
176 1978 Employees Whose Manager Left the Company Easy - -
177 1988 Find Cutoff Score for Each School Medium - -
178 1990 Count the Number of Experiments Medium - -
179 2004 The Number of Seniors and Juniors to Join the Company Hard - -
180 2010 The Number of Seniors and Juniors to Join the Company II Hard - -
181 2020 Number of Accounts That Did Not Stream Medium - -
182 2026 Low-Quality Problems Easy - -
183 2041 Accepted Candidates From the Interviews Medium - -
184 2051 The Category of Each Member in the Store Medium - -
185 2066 Account Balance Medium - -
186 2072 The Winner University Easy - -
187 2082 The Number of Rich Customers Easy - -
188 2084 Drop Type 1 Orders for Customers With Type 0 Orders Medium - -
189 2112 The Airport With the Most Traffic Medium - -
190 2118 Build the Equation Hard - -
191 2142 The Number of Passengers in Each Bus I Medium - -
192 2153 The Number of Passengers in Each Bus II Hard - -
193 2159 Order Two Columns Independently Medium - -
194 2173 Longest Winning Streak Hard - -
195 2175 The Change in Global Rankings Medium - -
196 2199 Finding the Topic of Each Post Hard - -
197 2205 The Number of Users That Are Eligible for Discount Easy - -
198 2228 Users With Two Purchases Within Seven Days Medium - -
199 2230 The Users That Are Eligible for Discount Easy - -
200 2238 Number of Times a Driver Was a Passenger Medium - -
201 2252 Dynamic Pivoting of a Table Hard - -
202 2253 Dynamic Unpivoting of a Table Hard - -
203 2292 Products With Three or More Orders in Two Consecutive Years Medium - -
204 2298 Tasks Count in the Weekend Medium - -
205 2308 Arrange Table by Gender Medium - -
206 2314 The First Day of the Maximum Recorded Degree in Each City Medium - -
207 2324 Product Sales Analysis IV Medium - -
208 2329 Product Sales Analysis V Easy - -
209 2339 All the Matches of the League Easy - -
210 2346 Compute the Rank as a Percentage Medium - -
211 2356 Number of Unique Subjects Taught by Each Teacher Easy - -
212 2362 Generate the Invoice Hard - -
213 2372 Calculate the Influence of Each Salesperson Medium - -
214 2377 Sort the Olympic Table Easy - -
215 2388 Change Null Values in a Table to the Previous Value Medium - -
216 2394 Employees With Deductions Medium - -
217 2474 Customers With Strictly Increasing Purchases Hard - -
218 2480 Form a Chemical Bond Easy - -
219 2494 Merge Overlapping Events in the Same Hall Hard - -
220 2504 Concatenate the Name and the Profession Easy - -

Releases

No releases published

Packages

No packages published