SELECT T1.first_name ,  T1.last_name ,  COUNT(*) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id GROUP BY T1.id ORDER BY COUNT(*) DESC LIMIT 10;
What are the top 10 customers' first and last names by total number of orders and how many orders did they make?
SELECT T1.first_name , T1.last_name , COUNT ( * ) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id = T1.id GROUP BY T1.id ORDER BY COUNT ( * ) DESC LIMIT 10 ;
select t1 . first_name , t1 . last_name , count ( * ) from customers as t1 join invoices as t2 on t2 . customer_id = t1 . id group by t1 . id order by count ( * ) desc limit value
What are the top 10 customers ' first and last names by total number of orders and how many orders did they make ?