Your Dashboard
Interview Coaching
Learn
System Design
ML System Design
Code
Behavioral
Salary Negotiation
Interview Guides
Search
⌘K
Get Premium
Leetcode 2292. Products With Three or More Orders in Two Consecutive Years
Find products that had at least three orders in some year and also at least three orders in the immediately following year. This is typically solved by grouping orders by product and year to count orders, then pairing counts for year y and y+1 (via self-join or window functions) to select products meeting the >=3 threshold in consecutive years.
Question Timeline
See when this question was last asked and where, including any notes left by other candidates.
All Regions
Comments
Hello Interview Premium
Your account is free and you can post anonymously if you choose.