vendredi 24 juin 2016

MySQL - Group orders count by clients numbers

I want to group order's count to show how many clients have that number of orders. I have come up with: select count(*) as quantidade_pedidos, clientes.id from pedidos inner join clientes on pedidos.cliente_id = clientes.id where pedidos.aprovado = 1 group by quantidade_pedidos but I just can't group by 'quantidade_pedidos' anyway. Is there any way to group by a temporary column? Another way of doing this? show how many clients (number) have that number of orders placed? Example 8 orders placed -> 3 clients have 8 orders placed etc

Aucun commentaire:

Enregistrer un commentaire