Skip to content
Avio Lines
Q8

Conditional Logic (CASE)

26 stations · 3.7h

CASE WHEN for categories, conditional counts and swapping values. 26 interview problems explained by Everyday Data Science (3.7h of video).

Start this line →
  1. Triangle JudgementLC 610 · 5:23
    EasyGoogle · Amazon · +3 more companiesLeetCode ↗ (opens in a new tab)
  2. Weather Type in Each CountryLC 1294 · 8:23 · LeetCode Premium
    EasyPoint72LeetCode ↗ (opens in a new tab)
  3. Create a Session Bar ChartLC 1435 · 16:45 · LeetCode Premium
    EasyTwitchLeetCode ↗ (opens in a new tab)
  4. Calculate Special BonusLC 1873 · 5:12
    EasyGoogle · MetaLeetCode ↗ (opens in a new tab)
  5. Apples & OrangesLC 1445 · 12:19 · LeetCode Premium
    MediumMetaLeetCode ↗ (opens in a new tab)
  6. Capital Gain/LossLC 1393 · 10:31
    MediumMeta · RobinhoodLeetCode ↗ (opens in a new tab)
  7. Number of Calls Between Two PersonsLC 1699 · 9:41 · LeetCode Premium
    MediumAmazonLeetCode ↗ (opens in a new tab)
  8. Immediate Food Delivery ILC 1173 · 6:13 · LeetCode Premium
    EasyDoorDashLeetCode ↗ (opens in a new tab)
  9. Calculate SalariesLC 1468 · 8:07 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  10. Customers Who Bought Products A and B but Not CLC 1398 · 13:56 · LeetCode Premium
    MediumMetaLeetCode ↗ (opens in a new tab)
  11. The Winner UniversityLC 2072 · 5:30 · LeetCode Premium
    EasyWalmart LabsLeetCode ↗ (opens in a new tab)
  12. Tree NodeLC 608 · 6:50
    MediumGoogle · Meta · +2 more companiesLeetCode ↗ (opens in a new tab)
  13. Exchange SeatsLC 626 · 8:38
    MediumGoogle · Amazon · +6 more companiesLeetCode ↗ (opens in a new tab)
  14. The Category of Each Member in the StoreLC 2051 · 16:13 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  15. Ads PerformanceLC 1322 · 7:17 · LeetCode Premium
    EasyMetaLeetCode ↗ (opens in a new tab)
  16. Team Scores in Football TournamentLC 1212 · 11:16 · LeetCode Premium
    MediumWayfairLeetCode ↗ (opens in a new tab)
  17. Evaluate Boolean ExpressionLC 1440 · 7:15 · LeetCode Premium
    MediumPoint72LeetCode ↗ (opens in a new tab)
  18. Count Salary CategoriesLC 1907 · 6:58
    MediumGoogle · Amazon · +4 more companiesLeetCode ↗ (opens in a new tab)
  19. Classifying Triangles by LengthsLC 3053 · 7:02 · LeetCode Premium
    EasyAonLeetCode ↗ (opens in a new tab)
  20. Snaps AnalysisLC 3056 · 6:10 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  21. Odd and Even TransactionsLC 3220 · 4:30
    MediumGoogleLeetCode ↗ (opens in a new tab)
  22. Binary Tree NodesLC 3054 · 4:33 · LeetCode Premium
    MediumGoogleLeetCode ↗ (opens in a new tab)
  23. Maximize ItemsLC 3052 · 10:22 · LeetCode Premium
    HardHashedInLeetCode ↗ (opens in a new tab)
  24. Trips and UsersLC 262 · 7:54
    HardGoogle · Amazon · +3 more companiesLeetCode ↗ (opens in a new tab)
  25. Immediate Food Delivery IIILC 2686 · 5:53 · LeetCode Premium
    MediumLeetCode ↗ (opens in a new tab)
  26. Find Golden Hour CustomersLC 3705 · 10:39
    MediumLeetCode ↗ (opens in a new tab)

All 26 stations in order

  1. 1.Triangle Judgement (LeetCode 610)
  2. 2.Weather Type in Each Country (LeetCode 1294)
  3. 3.Create a Session Bar Chart (LeetCode 1435)
  4. 4.Calculate Special Bonus (LeetCode 1873)
  5. 5.Apples & Oranges (LeetCode 1445)
  6. 6.Capital Gain/Loss (LeetCode 1393)
  7. 7.Number of Calls Between Two Persons (LeetCode 1699)
  8. 8.Immediate Food Delivery I (LeetCode 1173)
  9. 9.Calculate Salaries (LeetCode 1468)
  10. 10.Customers Who Bought Products A and B but Not C (LeetCode 1398)
  11. 11.The Winner University (LeetCode 2072)
  12. 12.Tree Node (LeetCode 608)
  13. 13.Exchange Seats (LeetCode 626)
  14. 14.The Category of Each Member in the Store (LeetCode 2051)
  15. 15.Ads Performance (LeetCode 1322)
  16. 16.Team Scores in Football Tournament (LeetCode 1212)
  17. 17.Evaluate Boolean Expression (LeetCode 1440)
  18. 18.Count Salary Categories (LeetCode 1907)
  19. 19.Classifying Triangles by Lengths (LeetCode 3053)
  20. 20.Snaps Analysis (LeetCode 3056)
  21. 21.Odd and Even Transactions (LeetCode 3220)
  22. 22.Binary Tree Nodes (LeetCode 3054)
  23. 23.Maximize Items (LeetCode 3052)
  24. 24.Trips and Users (LeetCode 262)
  25. 25.Immediate Food Delivery III (LeetCode 2686)
  26. 26.Find Golden Hour Customers (LeetCode 3705)