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.