Skip to content
Avio Lines
Q4

Subqueries

31 stations · 4.7h

Scalar, IN / NOT IN, EXISTS and correlated subqueries; Nth highest and 'bought all' problems. 31 interview problems explained by Everyday Data Science (4.7h of video), grouped into 4 patterns such as Nth highest, Matches every / all (relational division), NOT IN / NOT EXISTS.

Start this line →
problems by zone (pattern)
  • Nth highest3
  • Matches every / all (relational division)1
  • NOT IN / NOT EXISTS5
  • Correlated subquery2
  • Other20

  1. Nth highest

    0 of 3 passed
  2. Second Highest SalaryLC 176 · 9:44
    MediumGoogle · Amazon · +16 more companiesLeetCode ↗ (opens in a new tab)
  3. Nth Highest SalaryLC 177 · 6:35
    MediumGoogle · Amazon · +9 more companiesLeetCode ↗ (opens in a new tab)
  4. Department Highest SalaryLC 184 · 7:21
    MediumGoogle · Amazon · +3 more companiesLeetCode ↗ (opens in a new tab)

  5. Matches every / all (relational division)

    0 of 1 passed
  6. Customers Who Bought All ProductsLC 1045 · 7:01
    MediumGoogle · Amazon · +2 more companiesLeetCode ↗ (opens in a new tab)

  7. NOT IN / NOT EXISTS

    0 of 5 passed
  8. Customers Who Never OrderLC 183 · 17:35
    EasyGoogle · Amazon · +4 more companiesLeetCode ↗ (opens in a new tab)
  9. Students With Invalid DepartmentsLC 1350 · 5:27 · LeetCode Premium
    EasyAmazonLeetCode ↗ (opens in a new tab)
  10. Employees With Missing InformationLC 1965 · 13:07
    EasyGoogleLeetCode ↗ (opens in a new tab)
  11. Sellers With No SalesLC 1607 · 5:07 · LeetCode Premium
    EasyLeetCode ↗ (opens in a new tab)
  12. Employees Whose Manager Left the CompanyLC 1978 · 6:25
    EasyGoogle · Microsoft · +1 more companiesLeetCode ↗ (opens in a new tab)

  13. Correlated subquery

    0 of 2 passed
  14. Product Price at a Given DateLC 1164 · 9:50
    MediumGoogle · Amazon · +4 more companiesLeetCode ↗ (opens in a new tab)
  15. Find Cutoff Score for Each SchoolLC 1988 · 13:05 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)

  16. Other

    0 of 20 passed
  17. Biggest Single NumberLC 619 · 9:18
    EasyGoogle · Amazon · +3 more companiesLeetCode ↗ (opens in a new tab)
  18. Drop Type 1 Orders for Customers With Type 0 OrdersLC 2084 · 15:21 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  19. Sales Analysis ILC 1082 · 7:32 · LeetCode Premium
    EasyAmazonLeetCode ↗ (opens in a new tab)
  20. Sales PersonLC 607 · 6:44
    EasyGoogle · Meta · +1 more companiesLeetCode ↗ (opens in a new tab)
  21. Activity ParticipantsLC 1355 · 12:54 · LeetCode Premium
    MediumIBMLeetCode ↗ (opens in a new tab)
  22. The Airport With the Most TrafficLC 2112 · 10:28 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  23. Immediate Food Delivery IILC 1174 · 10:51
    MediumGoogle · Amazon · +5 more companiesLeetCode ↗ (opens in a new tab)
  24. Active BusinessesLC 1126 · 9:56 · LeetCode Premium
    MediumYelpLeetCode ↗ (opens in a new tab)
  25. Movie RatingLC 1341 · 12:04
    MediumGoogle · Amazon · +5 more companiesLeetCode ↗ (opens in a new tab)
  26. Game Play Analysis IILC 512 · 5:31 · LeetCode Premium
    EasyAmazon · GSN GamesLeetCode ↗ (opens in a new tab)
  27. Investments in 2016LC 585 · 17:36
    MediumGoogle · Amazon · +4 more companiesLeetCode ↗ (opens in a new tab)
  28. Project Employees IILC 1076 · 5:25 · LeetCode Premium
    EasyMetaLeetCode ↗ (opens in a new tab)
  29. Managers with at Least 5 Direct ReportsLC 570 · 5:31
    MediumGoogle · Amazon · +5 more companiesLeetCode ↗ (opens in a new tab)
  30. Winning CandidateLC 574 · 6:54 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  31. Sales Analysis IILC 1083 · 8:19 · LeetCode Premium
    EasyAmazonLeetCode ↗ (opens in a new tab)
  32. Page RecommendationsLC 1264 · 6:55 · LeetCode Premium
    MediumMetaLeetCode ↗ (opens in a new tab)
  33. Friend Requests II: Who Has the Most FriendsLC 602 · 7:09
    MediumGoogle · Amazon · +3 more companiesLeetCode ↗ (opens in a new tab)
  34. Product Sales Analysis IIILC 1070 · 5:59
    MediumGoogle · Amazon · +3 more companiesLeetCode ↗ (opens in a new tab)
  35. Game Play Analysis IVLC 550 · 8:35
    MediumGoogle · Amazon · +5 more companiesLeetCode ↗ (opens in a new tab)
  36. Popularity PercentageLC 2720 · 5:18 · LeetCode Premium
    HardLeetCode ↗ (opens in a new tab)

All 31 stations in order

  1. 1.Customers Who Never Order (LeetCode 183)
  2. 2.Biggest Single Number (LeetCode 619)
  3. 3.Students With Invalid Departments (LeetCode 1350)
  4. 4.Employees With Missing Information (LeetCode 1965)
  5. 5.Drop Type 1 Orders for Customers With Type 0 Orders (LeetCode 2084)
  6. 6.Sales Analysis I (LeetCode 1082)
  7. 7.Sales Person (LeetCode 607)
  8. 8.Activity Participants (LeetCode 1355)
  9. 9.The Airport With the Most Traffic (LeetCode 2112)
  10. 10.Product Price at a Given Date (LeetCode 1164)
  11. 11.Customers Who Bought All Products (LeetCode 1045)
  12. 12.Immediate Food Delivery II (LeetCode 1174)
  13. 13.Active Businesses (LeetCode 1126)
  14. 14.Second Highest Salary (LeetCode 176)
  15. 15.Find Cutoff Score for Each School (LeetCode 1988)
  16. 16.Movie Rating (LeetCode 1341)
  17. 17.Game Play Analysis II (LeetCode 512)
  18. 18.Sellers With No Sales (LeetCode 1607)
  19. 19.Investments in 2016 (LeetCode 585)
  20. 20.Employees Whose Manager Left the Company (LeetCode 1978)
  21. 21.Project Employees II (LeetCode 1076)
  22. 22.Nth Highest Salary (LeetCode 177)
  23. 23.Department Highest Salary (LeetCode 184)
  24. 24.Managers with at Least 5 Direct Reports (LeetCode 570)
  25. 25.Winning Candidate (LeetCode 574)
  26. 26.Sales Analysis II (LeetCode 1083)
  27. 27.Page Recommendations (LeetCode 1264)
  28. 28.Friend Requests II: Who Has the Most Friends (LeetCode 602)
  29. 29.Product Sales Analysis III (LeetCode 1070)
  30. 30.Game Play Analysis IV (LeetCode 550)
  31. 31.Popularity Percentage (LeetCode 2720)