Display of the top 3 customers by number of orders

Question

I am trying to find out the top 3 customers from a list. I want to do this based on the number of orders.

At the end I would like to be able to display the following values:

My output table is like the following just with way more clients

user_5514747 · Answer

You may use below formula.

=QUERY(A1:C,"select A, count(A), sum(C) 
where A is not null 
group by A 
order by count(A) DESC 
limit 3")

user_19663739 · Answer

Try following query

Select Client,Count(Client) 'Amount of Orders',Sum(Amount) 'Summed Amount of 
Ordervalue' From OrderDetails Group By Client

user_19949013 · Answer

try following

Select Client,Count(Client) 'Amount of Orders',Sum(Amount) 'Summed Amount of 
Ordervalue' From OrderDetails Group By Client