Leetcode 1596. The Most Frequently Ordered Products for Each Customer

Given a table of customer orders, compute for each customer the product(s) they ordered the most times — returning all products tied for the highest count. This requires grouping and counting orders per (customer, product) and then selecting per-customer maxima (commonly solved with aggregation plus a window function or a self-join).