Skip to content
Avio Lines
Q10

Recursive CTEs

14 stations · 3.3h

Generating sequences and walking hierarchies with WITH RECURSIVE. 14 interview problems explained by Everyday Data Science (3.3h of video).

Start this line →
  1. Find the Subtasks That Did Not ExecuteLC 1767 · 10:26 · LeetCode Premium
    HardGoogleLeetCode ↗ (opens in a new tab)
  2. Find the Missing IDsLC 1613 · 6:04 · LeetCode Premium
    MediumAmazonLeetCode ↗ (opens in a new tab)
  3. Find the Subtasks That Did Not ExecuteLC 1767 · 10:37 · LeetCode Premium
    HardGoogleLeetCode ↗ (opens in a new tab)
  4. CEO Subordinate HierarchyLC 3236 · 12:05 · LeetCode Premium
    HardLeetCode ↗ (opens in a new tab)
  5. Find Median Given Frequency of NumbersLC 571 · 13:23 · LeetCode Premium
    HardPinterestLeetCode ↗ (opens in a new tab)
  6. Number of Transactions per VisitLC 1336 · 16:02 · LeetCode Premium
    HardMachine ZoneLeetCode ↗ (opens in a new tab)
  7. Hopper Company Queries ILC 1635 · 13:08 · LeetCode Premium
    HardUberLeetCode ↗ (opens in a new tab)
  8. Hopper Company Queries IILC 1645 · 13:24 · LeetCode Premium
    HardUberLeetCode ↗ (opens in a new tab)
  9. Students Report By GeographyLC 618 · 11:01 · LeetCode Premium
    HardLeetCode ↗ (opens in a new tab)
  10. Friday Purchases IILC 2994 · 15:43 · LeetCode Premium
    HardLeetCode ↗ (opens in a new tab)
  11. Friday Purchase IIILC 3118 · 15:59 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  12. Hopper Company Queries IIILC 1651 · 14:39 · LeetCode Premium
    HardUberLeetCode ↗ (opens in a new tab)
  13. Analyze Organization HierarchyLC 3482 · 28:24
    HardAmazonLeetCode ↗ (opens in a new tab)
  14. First Letter CapitalizationLC 3368 · 17:05 · LeetCode Premium
    HardLeetCode ↗ (opens in a new tab)

All 14 stations in order

  1. 1.Find the Subtasks That Did Not Execute (LeetCode 1767)
  2. 2.Find the Missing IDs (LeetCode 1613)
  3. 3.Find the Subtasks That Did Not Execute (LeetCode 1767)
  4. 4.CEO Subordinate Hierarchy (LeetCode 3236)
  5. 5.Find Median Given Frequency of Numbers (LeetCode 571)
  6. 6.Number of Transactions per Visit (LeetCode 1336)
  7. 7.Hopper Company Queries I (LeetCode 1635)
  8. 8.Hopper Company Queries II (LeetCode 1645)
  9. 9.Students Report By Geography (LeetCode 618)
  10. 10.Friday Purchases II (LeetCode 2994)
  11. 11.Friday Purchase III (LeetCode 3118)
  12. 12.Hopper Company Queries III (LeetCode 1651)
  13. 13.Analyze Organization Hierarchy (LeetCode 3482)
  14. 14.First Letter Capitalization (LeetCode 3368)