Customer Placing the Largest Number of Orders


  • 0

    Click here to see the full article post


  • 0
    Y

    How would you update this to handle the case where there could be more than one numbers occurring the same number of maximum times?


  • 0
    P

    I think this can handle more than one numbers occurring the same number of max times:
    SELECT customer_number FROM orders
    GROUP BY customer_number
    having count(distinct order_number) IN
    (SELECT MAX(countn) FROM (select count(distinct order_number) as countn FROM orders GROUP BY customer_number) sub)


Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.