How many invoices are from the US?
select count ( * ) from invoices where billing_country = "USA"
Could you list them grouped by state?
select billing_state, count ( * ) from invoices where billing_country = "USA" group by billing_state
Could you list the number of invoices grouped by country?
select billing_country, count ( * ) from invoices group by billing_country
Can you list the number of invoices from the US grouped by billing city?
select billing_city, count ( * ) from invoices where billing_country = "USA" group by billing_city
Can you list the number of invoices from all countries except the US grouped by billing city?
select billing_city, count ( * ) from invoices where billing_country ! = "USA" group by billing_city