MySql Query - Number of orders per customer

[riteshuae]

Hi i have installed prestashop 1.4.8.2, i want report from mysql, Number of orders per customer with customer name & customer id plus i want total amount of order customer wise.

can you help me with SQL query so i can generate this report from phpmyadmin.

thanks,

regards,
Ritesh

[pritaeas]

What are the table structures, and what have you tried?

[riteshuae]

i have tried below code, but getting syntax error.

SELECT customers_firstname, customers_lastname,o.Number
FROM customers 
INNER JOIN (Select customer_id, count(*) as Number from orders Group by customer_id order by Number desc limit 5)AS o
on customers.customers_id = o.customer_id ;

#1064 - you have an error in your sql syntax (line number 5)

[urtrivedi]

I am writing sample query

select a.id_customer, b.firstname,b.lastname, count(*) total_orders from orders a inner join customer b on a.id_customer=b.id_customer group by a.id_customer b.firstname,b.lastname

[riteshuae]

thanks, i have littlebit modified & its working. thanks a lot.