| 0175 |
Combine Two Tables |
Database |
Easy |
|
| 0176 |
Second Highest Salary |
Database |
Medium |
|
| 0177 |
Nth Highest Salary |
Database |
Medium |
|
| 0178 |
Rank Scores |
Database |
Medium |
|
| 0180 |
Consecutive Numbers |
Database |
Medium |
|
| 0181 |
Employees Earning More Than Their Managers |
Database |
Easy |
|
| 0182 |
Duplicate Emails |
Database |
Easy |
|
| 0183 |
Customers Who Never Order |
Database |
Easy |
|
| 0184 |
Department Highest Salary |
Database |
Medium |
|
| 0185 |
Department Top Three Salaries |
Database |
Hard |
|
| 0196 |
Delete Duplicate Emails |
Database |
Easy |
|
| 0197 |
Rising Temperature |
Database |
Easy |
|
| 0262 |
Trips and Users |
Database |
Hard |
|
| 0511 |
Game Play Analysis I |
Database |
Easy |
|
| 0512 |
Game Play Analysis II |
Database |
Easy |
๐ |
| 0534 |
Game Play Analysis III |
Database |
Medium |
๐ |
| 0550 |
Game Play Analysis IV |
Database |
Medium |
|
| 0569 |
Median Employee Salary |
Database |
Hard |
๐ |
| 0570 |
Managers with at Least 5 Direct Reports |
Database |
Medium |
|
| 0571 |
Find Median Given Frequency of Numbers |
Database |
Hard |
๐ |
| 0574 |
Winning Candidate |
Database |
Medium |
๐ |
| 0577 |
Employee Bonus |
Database |
Easy |
|
| 0578 |
Get Highest Answer Rate Question |
Database |
Medium |
๐ |
| 0579 |
Find Cumulative Salary of an Employee |
Database |
Hard |
๐ |
| 0580 |
Count Student Number in Departments |
Database |
Medium |
๐ |
| 0584 |
Find Customer Referee |
Database |
Easy |
|
| 0585 |
Investments in 2016 |
Database |
Medium |
|
| 0586 |
Customer Placing the Largest Number of Orders |
Database |
Easy |
|
| 0595 |
Big Countries |
Database |
Easy |
|
| 0596 |
Classes More Than 5 Students |
Database |
Easy |
|
| 0597 |
Friend Requests I Overall Acceptance Rate |
Database |
Easy |
๐ |
| 0601 |
Human Traffic of Stadium |
Database |
Hard |
|
| 0602 |
Friend Requests II Who Has the Most Friends |
Database |
Medium |
|
| 0603 |
Consecutive Available Seats |
Database |
Easy |
๐ |
| 0607 |
Sales Person |
Database |
Easy |
|
| 0608 |
Tree Node |
Database |
Medium |
|
| 0610 |
Triangle Judgement |
Database |
Easy |
|
| 0612 |
Shortest Distance in a Plane |
Database |
Medium |
๐ |
| 0613 |
Shortest Distance in a Line |
Database |
Easy |
๐ |
| 0614 |
Second Degree Follower |
Database |
Medium |
๐ |
| 0615 |
Average Salary Departments VS Company |
Database |
Hard |
๐ |
| 0618 |
Students Report By Geography |
Database |
Hard |
๐ |
| 0619 |
Biggest Single Number |
Database |
Easy |
|
| 0620 |
Not Boring Movies |
Database |
Easy |
|
| 0626 |
Exchange Seats |
Database |
Medium |
|
| 0627 |
Swap Salary |
Database |
Easy |
|
| 1045 |
Customers Who Bought All Products |
Database |
Medium |
|
| 1050 |
Actors and Directors Who Cooperated At Least Three Times |
Database |
Easy |
|
| 1068 |
Product Sales Analysis I |
Database |
Easy |
|
| 1069 |
Product Sales Analysis II |
Database |
Easy |
๐ |
| 1070 |
Product Sales Analysis III |
Database |
Medium |
|
| 1075 |
Project Employees I |
Database |
Easy |
|
| 1076 |
Project Employees II |
Database |
Easy |
๐ |
| 1077 |
Project Employees III |
Database |
Medium |
๐ |
| 1082 |
Sales Analysis I |
Database |
Easy |
๐ |
| 1083 |
Sales Analysis II |
Database |
Easy |
๐ |
| 1084 |
Sales Analysis III |
Database |
Easy |
|
| 1097 |
Game Play Analysis V |
Database |
Hard |
๐ |
| 1098 |
Unpopular Books |
Database |
Medium |
๐ |
| 1107 |
New Users Daily Count |
Database |
Medium |
๐ |
| 1112 |
Highest Grade For Each Student |
Database |
Medium |
๐ |
| 1113 |
Reported Posts |
Database |
Easy |
๐ |
| 1126 |
Active Businesses |
Database |
Medium |
๐ |
| 1127 |
User Purchase Platform |
Database |
Hard |
๐ |
| 1132 |
Reported Posts II |
Database |
Medium |
๐ |
| 1141 |
User Activity for the Past 30 Days I |
Database |
Easy |
|
| 1142 |
User Activity for the Past 30 Days II |
Database |
Easy |
๐ |
| 1148 |
Article Views I |
Database |
Easy |
|
| 1149 |
Article Views II |
Database |
Medium |
๐ |
| 1158 |
Market Analysis I |
Database |
Medium |
|
| 1159 |
Market Analysis II |
Database |
Hard |
๐ |
| 1164 |
Product Price at a Given Date |
Database |
Medium |
|
| 1173 |
Immediate Food Delivery I |
Database |
Easy |
๐ |
| 1174 |
Immediate Food Delivery II |
Database |
Medium |
|
| 1179 |
Reformat Department Table |
Database |
Easy |
|
| 1193 |
Monthly Transactions I |
Database |
Medium |
|
| 1194 |
Tournament Winners |
Database |
Hard |
๐ |
| 1204 |
Last Person to Fit in the Bus |
Database |
Medium |
|
| 1205 |
Monthly Transactions II |
Database |
Medium |
๐ |
| 1211 |
Queries Quality and Percentage |
Database |
Easy |
|
| 1212 |
Team Scores in Football Tournament |
Database |
Medium |
๐ |
| 1225 |
Report Contiguous Dates |
Database |
Hard |
๐ |
| 1241 |
Number of Comments per Post |
Database |
Easy |
๐ |
| 1251 |
Average Selling Price |
Database |
Easy |
|
| 1264 |
Page Recommendations |
Database |
Medium |
๐ |
| 1270 |
All People Report to the Given Manager |
Database |
Medium |
๐ |
| 1280 |
Students and Examinations |
Database |
Easy |
|
| 1285 |
Find the Start and End Number of Continuous Ranges |
Database |
Medium |
๐ |
| 1294 |
Weather Type in Each Country |
Database |
Easy |
๐ |
| 1303 |
Find the Team Size |
Database |
Easy |
๐ |
| 1308 |
Running Total for Different Genders |
Database |
Medium |
๐ |
| 1321 |
Restaurant Growth |
Database |
Medium |
|
| 1322 |
Ads Performance |
Database |
Easy |
๐ |
| 1327 |
List the Products Ordered in a Period |
Database |
Easy |
|
| 1336 |
Number of Transactions per Visit |
Database |
Hard |
๐ |
| 1341 |
Movie Rating |
Database |
Medium |
|
| 1350 |
Students With Invalid Departments |
Database |
Easy |
๐ |
| 1355 |
Activity Participants |
Database |
Medium |
๐ |
| 1364 |
Number of Trusted Contacts of a Customer |
Database |
Medium |
๐ |
| 1369 |
Get the Second Most Recent Activity |
Database |
Hard |
๐ |
| 1378 |
Replace Employee ID With The Unique Identifier |
Database |
Easy |
|
| 1384 |
Total Sales Amount by Year |
Database |
Hard |
๐ |
| 1393 |
Capital GainLoss |
Database |
Medium |
|
| 1398 |
Customers Who Bought Products A and B but Not C |
Database |
Medium |
๐ |
| 1407 |
Top Travellers |
Database |
Easy |
|
| 1412 |
Find the Quiet Students in All Exams |
Database |
Hard |
๐ |
| 1421 |
NPV Queries |
Database |
Easy |
๐ |
| 1435 |
Create a Session Bar Chart |
Database |
Easy |
๐ |
| 1440 |
Evaluate Boolean Expression |
Database |
Medium |
๐ |
| 1445 |
Apples & Oranges |
Database |
Medium |
๐ |
| 1454 |
Active Users |
Database |
Medium |
๐ |
| 1459 |
Rectangles Area |
Database |
Medium |
๐ |
| 1468 |
Calculate Salaries |
Database |
Medium |
๐ |
| 1479 |
Sales by Day of the Week |
Database |
Hard |
๐ |
| 1484 |
Group Sold Products By The Date |
Database |
Easy |
|
| 1495 |
Friendly Movies Streamed Last Month |
Database |
Easy |
๐ |
| 1501 |
Countries You Can Safely Invest In |
Database |
Medium |
๐ |
| 1511 |
Customer Order Frequency |
Database |
Easy |
๐ |
| 1517 |
Find Users With Valid E-Mails |
Database |
Easy |
|
| 1527 |
Patients With a Condition |
Database |
Easy |
|
| 1532 |
The Most Recent Three Orders |
Database |
Medium |
๐ |
| 1543 |
Fix Product Name Format |
Database |
Easy |
๐ |
| 1549 |
The Most Recent Orders for Each Product |
Database |
Medium |
๐ |
| 1555 |
Bank Account Summary |
Database |
Medium |
๐ |
| 1565 |
Unique Orders and Customers Per Month |
Database |
Easy |
๐ |
| 1571 |
Warehouse Manager |
Database |
Easy |
๐ |
| 1581 |
Customer Who Visited but Did Not Make Any Transactions |
Database |
Easy |
|
| 1587 |
Bank Account Summary II |
Database |
Easy |
|
| 1596 |
The Most Frequently Ordered Products for Each Customer |
Database |
Medium |
๐ |
| 1607 |
Sellers With No Sales |
Database |
Easy |
๐ |
| 1613 |
Find the Missing IDs |
Database |
Medium |
๐ |
| 1623 |
All Valid Triplets That Can Represent a Country |
Database |
Easy |
๐ |
| 1633 |
Percentage of Users Attended a Contest |
Database |
Easy |
|
| 1635 |
Hopper Company Queries I |
Database |
Hard |
๐ |
| 1645 |
Hopper Company Queries II |
Database |
Hard |
๐ |
| 1651 |
Hopper Company Queries III |
Database |
Hard |
๐ |
| 1661 |
Average Time of Process per Machine |
Database |
Easy |
|
| 1667 |
Fix Names in a Table |
Database |
Easy |
|
| 1677 |
Product's Worth Over Invoices |
Database |
Easy |
๐ |
| 1683 |
Invalid Tweets |
Database |
Easy |
|
| 1693 |
Daily Leads and Partners |
Database |
Easy |
|
| 1699 |
Number of Calls Between Two Persons |
Database |
Medium |
๐ |
| 1709 |
Biggest Window Between Visits |
Database |
Medium |
๐ |
| 1715 |
Count Apples and Oranges |
Database |
Medium |
๐ |
| 1729 |
Find Followers Count |
Database |
Easy |
|
| 1731 |
The Number of Employees Which Report to Each Employee |
Database |
Easy |
|
| 1741 |
Find Total Time Spent by Each Employee |
Database |
Easy |
|
| 1747 |
Leetflex Banned Accounts |
Database |
Medium |
๐ |
| 1757 |
Recyclable and Low Fat Products |
Database |
Easy |
|
| 1767 |
Find the Subtasks That Did Not Execute |
Database |
Hard |
๐ |
| 1777 |
Product's Price for Each Store |
Database |
Easy |
๐ |
| 1783 |
Grand Slam Titles |
Database |
Medium |
๐ |
| 1789 |
Primary Department for Each Employee |
Database |
Easy |
|
| 1795 |
Rearrange Products Table |
Database |
Easy |
|
| 1809 |
Ad-Free Sessions |
Database |
Easy |
๐ |
| 1811 |
Find Interview Candidates |
Database |
Medium |
๐ |
| 1821 |
Find Customers With Positive Revenue this Year |
Database |
Easy |
๐ |
| 1831 |
Maximum Transaction Each Day |
Database |
Medium |
๐ |
| 1841 |
League Statistics |
Database |
Medium |
๐ |
| 1843 |
Suspicious Bank Accounts |
Database |
Medium |
๐ |
| 1853 |
Convert Date Format |
Database |
Easy |
๐ |
| 1867 |
Orders With Maximum Quantity Above Average |
Database |
Medium |
๐ |
| 1873 |
Calculate Special Bonus |
Database |
Easy |
|
| 1875 |
Group Employees of the Same Salary |
Database |
Medium |
๐ |
| 1890 |
The Latest Login in 2020 |
Database |
Easy |
|
| 1892 |
Page Recommendations II |
Database |
Hard |
๐ |
| 1907 |
Count Salary Categories |
Database |
Medium |
|
| 1917 |
Leetcodify Friends Recommendations |
Database |
Hard |
๐ |
| 1919 |
Leetcodify Similar Friends |
Database |
Hard |
๐ |
| 1934 |
Confirmation Rate |
Database |
Medium |
|
| 1939 |
Users That Actively Request Confirmation Messages |
Database |
Easy |
๐ |
| 1949 |
Strong Friendship |
Database |
Medium |
๐ |
| 1951 |
All the Pairs With the Maximum Number of Common Followers |
Database |
Medium |
๐ |
| 1965 |
Employees With Missing Information |
Database |
Easy |
|
| 1972 |
First and Last Call On the Same Day |
Database |
Hard |
๐ |
| 1978 |
Employees Whose Manager Left the Company |
Database |
Easy |
|
| 1988 |
Find Cutoff Score for Each School |
Database |
Medium |
๐ |
| 1990 |
Count the Number of Experiments |
Database |
Medium |
๐ |
| 2004 |
The Number of Seniors and Juniors to Join the Company |
Database |
Hard |
๐ |
| 2010 |
The Number of Seniors and Juniors to Join the Company II |
Database |
Hard |
๐ |
| 2020 |
Number of Accounts That Did Not Stream |
Database |
Medium |
๐ |
| 2026 |
Low-Quality Problems |
Database |
Easy |
๐ |
| 2041 |
Accepted Candidates From the Interviews |
Database |
Medium |
๐ |
| 2051 |
The Category of Each Member in the Store |
Database |
Medium |
๐ |
| 2066 |
Account Balance |
Database |
Medium |
๐ |
| 2072 |
The Winner University |
Database |
Easy |
๐ |
| 2082 |
The Number of Rich Customers |
Database |
Easy |
๐ |
| 2084 |
Drop Type 1 Orders for Customers With Type 0 Orders |
Database |
Medium |
๐ |
| 2112 |
The Airport With the Most Traffic |
Database |
Medium |
๐ |
| 2118 |
Build the Equation |
Database |
Hard |
๐ |
| 2142 |
The Number of Passengers in Each Bus I |
Database |
Medium |
๐ |
| 2153 |
The Number of Passengers in Each Bus II |
Database |
Hard |
๐ |
| 2159 |
Order Two Columns Independently |
Database |
Medium |
๐ |
| 2173 |
Longest Winning Streak |
Database |
Hard |
๐ |
| 2175 |
The Change in Global Rankings |
Database |
Medium |
๐ |
| 2199 |
Finding the Topic of Each Post |
Database |
Hard |
๐ |
| 2205 |
The Number of Users That Are Eligible for Discount |
Database |
Easy |
๐ |
| 2228 |
Users With Two Purchases Within Seven Days |
Database |
Medium |
๐ |
| 2230 |
The Users That Are Eligible for Discount |
Database |
Easy |
๐ |
| 2238 |
Number of Times a Driver Was a Passenger |
Database |
Medium |
๐ |
| 2252 |
Dynamic Pivoting of a Table |
Database |
Hard |
๐ |
| 2253 |
Dynamic Unpivoting of a Table |
Database |
Hard |
๐ |
| 2292 |
Products With Three or More Orders in Two Consecutive Years |
Database |
Medium |
๐ |
| 2298 |
Tasks Count in the Weekend |
Database |
Medium |
๐ |
| 2308 |
Arrange Table by Gender |
Database |
Medium |
๐ |
| 2314 |
The First Day of the Maximum Recorded Degree in Each City |
Database |
Medium |
๐ |
| 2324 |
Product Sales Analysis IV |
Database |
Medium |
๐ |
| 2329 |
Product Sales Analysis V |
Database |
Easy |
๐ |
| 2339 |
All the Matches of the League |
Database |
Easy |
๐ |
| 2346 |
Compute the Rank as a Percentage |
Database |
Medium |
๐ |
| 2356 |
Number of Unique Subjects Taught by Each Teacher |
Database |
Easy |
|
| 2362 |
Generate the Invoice |
Database |
Hard |
๐ |
| 2372 |
Calculate the Influence of Each Salesperson |
Database |
Medium |
๐ |
| 2377 |
Sort the Olympic Table |
Database |
Easy |
๐ |
| 2388 |
Change Null Values in a Table to the Previous Value |
Database |
Medium |
๐ |
| 2394 |
Employees With Deductions |
Database |
Medium |
๐ |
| 2474 |
Customers With Strictly Increasing Purchases |
Database |
Hard |
๐ |
| 2480 |
Form a Chemical Bond |
Database |
Easy |
๐ |
| 2494 |
Merge Overlapping Events in the Same Hall |
Database |
Hard |
๐ |
| 2504 |
Concatenate the Name and the Profession |
Database |
Easy |
๐ |
| 2668 |
Find Latest Salaries |
Database |
Easy |
๐ |
| 2669 |
Count Artist Occurrences On Spotify Ranking List |
Database |
Easy |
๐ |
| 2686 |
Immediate Food Delivery III |
Database |
Medium |
๐ |
| 2687 |
Bikes Last Time Used |
Database |
Easy |
๐ |
| 2688 |
Find Active Users |
Database |
Medium |
๐ |
| 2701 |
Consecutive Transactions with Increasing Amounts |
Database |
Hard |
๐ |
| 2720 |
Popularity Percentage |
Database |
Hard |
๐ |
| 2738 |
Count Occurrences in Text |
Database |
Medium |
๐ |
| 2752 |
Customers with Maximum Number of Transactions on Consecutive Days |
Database |
Hard |
๐ |
| 2783 |
Flight Occupancy and Waitlist Analysis |
Database |
Medium |
๐ |
| 2793 |
Status of Flight Tickets |
|
Hard |
๐ |
| 2820 |
Election Results |
|
Medium |
๐ |
| 2837 |
Total Traveled Distance |
Database |
Easy |
๐ |
| 2853 |
Highest Salaries Difference |
Database |
Easy |
๐ |
| 2854 |
Rolling Average Steps |
Database |
Medium |
๐ |
| 2893 |
Calculate Orders Within Each Interval |
Database |
Medium |
๐ |
| 2922 |
Market Analysis III |
Database |
Medium |
๐ |
| 2978 |
Symmetric Coordinates |
Database |
Medium |
๐ |
| 2984 |
Find Peak Calling Hours for Each City |
Database |
Medium |
๐ |
| 2985 |
Calculate Compressed Mean |
Database |
Easy |
๐ |
| 2986 |
Find Third Transaction |
Database |
Medium |
๐ |
| 2987 |
Find Expensive Cities |
Database |
Easy |
๐ |
| 2988 |
Manager of the Largest Department |
Database |
Medium |
๐ |
| 2989 |
Class Performance |
Database |
Medium |
๐ |
| 2990 |
Loan Types |
Database |
Easy |
๐ |
| 2991 |
Top Three Wineries |
Database |
Hard |
๐ |
| 2993 |
Friday Purchases I |
Database |
Medium |
๐ |
| 2994 |
Friday Purchases II |
Database |
Hard |
๐ |
| 2995 |
Viewers Turned Streamers |
Database |
Hard |
๐ |
| 3050 |
Pizza Toppings Cost Analysis |
Database |
Medium |
๐ |
| 3051 |
Find Candidates for Data Scientist Position |
Database |
Easy |
๐ |
| 3052 |
Maximize Items |
Database |
Hard |
๐ |
| 3053 |
Classifying Triangles by Lengths |
Database |
Easy |
๐ |
| 3054 |
Binary Tree Nodes |
Database |
Medium |
๐ |
| 3055 |
Top Percentile Fraud |
Database |
Medium |
๐ |
| 3056 |
Snaps Analysis |
Database |
Medium |
๐ |
| 3057 |
Employees Project Allocation |
Database |
Hard |
๐ |
| 3058 |
Friends With No Mutual Friends |
Database |
Medium |
๐ |
| 3059 |
Find All Unique Email Domains |
Database |
Easy |
๐ |
| 3060 |
User Activities within Time Bounds |
Database |
Hard |
๐ |
| 3061 |
Calculate Trapping Rain Water |
Database |
Hard |
๐ |
| 3087 |
Find Trending Hashtags |
Database |
Medium |
๐ |
| 3089 |
Find Bursty Behavior |
Database |
Medium |
๐ |
| 3103 |
Find Trending Hashtags II |
Database |
Hard |
๐ |
| 3118 |
Friday Purchase III |
Database |
Medium |
๐ |
| 3124 |
Find Longest Calls |
Database |
Medium |
๐ |
| 3126 |
Server Utilization Time |
Database |
Medium |
๐ |
| 3140 |
Consecutive Available Seats II |
Database |
Medium |
๐ |
| 3150 |
Invalid Tweets II |
Database |
Easy |
๐ |
| 3156 |
Employee Task Duration and Concurrent Tasks |
Database |
Hard |
๐ |
| 3166 |
Calculate Parking Fees and Duration |
Database |
Medium |
๐ |
| 3172 |
Second Day Verification |
Database |
Easy |
๐ |
| 3182 |
Find Top Scoring Students |
Database |
Medium |
๐ |
| 3188 |
Find Top Scoring Students II |
Database |
Hard |
๐ |
| 3198 |
Find Cities in Each State |
Database |
Easy |
๐ |
| 3204 |
Bitwise User Permissions Analysis |
Database |
Medium |
๐ |
| 3214 |
Year on Year Growth Rate |
Database |
Hard |
๐ |
| 3220 |
Odd and Even Transactions |
Database |
Medium |
|
| 3230 |
Customer Purchasing Behavior Analysis |
Database |
Medium |
๐ |
| 3236 |
CEO Subordinate Hierarchy |
Database |
Hard |
๐ |
| 3246 |
Premier League Table Ranking |
Database |
Easy |
๐ |
| 3252 |
Premier League Table Ranking II |
Database |
Medium |
๐ |
| 3262 |
Find Overlapping Shifts |
|
Medium |
๐ |
