Show me the number of invoices by country!
select billing_country, count(*) from invoices group by billing_country;
What is the total invoice for each!
select billing_country, count(*), sum(total) from invoices group by billing_country;
Can you show me this sorted from greatest to least by total invoice size!
select billing_country, count(*), sum(total) from invoices group by billing_country order by sum(total) desc;
Now, show me just the billing country and total for the top 8!
select billing_country, sum(total) from invoices group by billing_country order by sum(total) desc limit 8;