Please show me a list of the top 5 countries by number of invoices. List country name.
select billing_country from invoices group by billing_country order by count ( * ) desc limit 5
OK! Can you also show me the number of invoices for these 5 countries.
select billing_country,count ( * ) from invoices group by billing_country order by count ( * ) desc limit 5
May I also see the names of bottom 5 countries by number of invoices. Please show me country names and number of invoices.
select billing_country, count ( * ) from invoices group by billing_country order by count ( * ) limit 5
Can you show me the postal codes for these countries.
select billing_country,billing_postal_code from invoices group by billing_country order by count ( * ) limit 5