Don't know what to make of the subquery COUNT (*),
I understood as a "statistical how many meet the conditions of the orders. The id=customers. Id orders" are right? Finally you should output a 5
Why the computer will know that the mean of each customer orders, but also can bring each customer to separate automatically, and then grouping statistics?