SELECT T1.first_name ,  T1.last_name ,  SUM(T2.total) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id  =  T1.id GROUP BY T1.id ORDER BY SUM(T2.total) DESC LIMIT 10;
List the top 10 customers by total gross sales. List customers' first and last name and total gross sales.
SELECT T1.first_name , T1.last_name , SUM ( T2.total ) FROM customers AS T1 JOIN invoices AS T2 ON T2.customer_id = T1.id GROUP BY T1.id ORDER BY SUM ( T2.total ) DESC LIMIT 10 ;
select t1 . first_name , t1 . last_name , sum ( t2 . total ) from customers as t1 join invoices as t2 on t2 . customer_id = t1 . id group by t1 . id order by sum ( t2 . total ) desc limit value
List the top 10 customers by total gross sales . List customers ' first and last name and total gross sales .