I have the following simple table:
CustomerID CustomerName NumOfOrders
1 Joe 15
2 Jane 20
7 Clara 1
I want to find the customer with maximum number of orders. Seems trivial enough but I can,t seem to find a solution.