First and Last Call On the Same Day (LeetCode 1972)
HardLeetCode 1972 · Compare with previous / next row · Amazon · 9:54· LeetCode PremiumLeetcode HARD 1972 - First & Last Call on Same Day - FIRST_VALUE() WINDOW Function -Explained by EDSMy notes
Sign in to keep private notes on every station, with video timestamps.
Pause here and write your approach in two lines. Compare it with MIK's when the video ends.
Sign in to write your approach →About this video
Video solution for LeetCode 1972 First and Last Call On the Same Day by Everyday Data Science: Window Functions, Hard. Topics: Database. Watch the explanation, then solve it on LeetCode.
- Difficulty
- hard
- Topics
- Database
- Patterns
- Compare with previous / next row
- Asked at
- Amazon
- Chapter
- Window Functions
- Duration
- 9:54
Related problems
- The Change in Global Rankings (LeetCode 2175)
- Year on Year Growth Rate (LeetCode 3214)
- Change Null Values in a Table to the Previous Value (LeetCode 2388)
- Find Active Users (LeetCode 2688)
- Find Consistently Improving Employees (LeetCode 3580)
- Find COVID Recovery Patients (LeetCode 3586)
- Find Churn Risk Customers (LeetCode 3716)