Skip to content

rajtuts/Advanced-SQL-50

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

LeetCode Advanced SQL 50

Table of Contents

Select

# Problem Level Status
1821 Find Customers With Positive Revenue this Year Easy Solved
183 Customers Who Never Order Easy Solved
1873 Calculate Special Bonus Easy Solved
1398 Customers Who Bought Products A and B but Not C Medium Solved
1112 Highest Grade For Each Student Medium Solved

Basic Joins

# Problem Level Status
0175 Combine Two Tables Easy Solved
1067 Product Sales Analysis I Easy Solved
1407 Top Travellers Easy Solved
0607 Sales Person Easy Solved
1440 Evaluate Boolean Expression Medium Solved
1212 Team Scores in Football Tournament Medium Solved

Basic Aggregate Functions

# Problem Level Status
1890 The Latest Login in 2020 Easy Solved
0511 Game Play Analysis I Easy Solved
1571 Warehouse Manager Easy Solved
0586 Customer Placing the Largest Number of Orders Easy Solved
1741 Find Total Time Spent by Each Employee Easy Solved
1173 Immediate Food Delivery I Easy Solved
1445 Apples & Oranges Medium Solved
1699 Number of Calls Between Two Persons Medium Solved

Sorting and Grouping

# Problem Level Status
1587 Bank Account Summary II Easy Solved
0182 Duplicate Emails Easy -
1050 Customer Order Frequency Easy -
1511 Customer Order Frequency Easy -
1693 Daily Leads and Partners Easy -
1495 Friendly Movies Streamed Last Month Easy -
1501 Countries You Can Safely Invest In Medium -

Advanced Select and Joins

# Problem Level Status
0603 Consecutive Available Seats Easy -
1795 Rearrange Products Table Easy -
0613 Shortest Distance in a Line Easy -
1965 Employees With Missing Information Easy -
1264 Page Recommendations Medium -
0608 Tree Node Medium -
0534 Game Play Analysis III Medium -
1783 Grand Slam Titles Medium -
1747 Leetflex Banned Accounts Medium -

Subqueries

# Problem Level Status
1350 Students With Invalid Departments Easy -
1303 Find the Team Size Easy -
0512 Game Play Analysis II Easy -
0184 Department Highest Salary Medium -
1549 The Most Recent Orders for Each Product Medium -
1532 The Most Recent Three Orders Medium -
1831 Maximum Transaction Each Day Medium -

Advanced Topics: Window Function and CTE

# Problem Level Status
1077 Project Employees III Medium -
1285 Find the Start and End Number of Continuous Ranges Medium -
1596 The Most Frequently Ordered Products for Each Customer Medium ***
1709 Biggest Window Between Visits Medium ***
1270 All People Report to the Given Manager Medium ***
1412 Find the Quiet Students in All Exams Hard ***
1767 Find the Subtasks That Did Not Execute Hard ***
1225 Report Contiguous Dates Hard ***

About

LeetCode Premium Advanced SQL 50 List- Solved 50/50 problems

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published