Show me all the information about the invoices in California!
select * from invoices where billing_state = "CA";
Actually just show the billing_state, billing_city, and billing_country.
select billing_state, billing_city, billing_country from invoices where billing_state = "CA";
Can you show the billing_state and the total invoice of these?
select billing_state, sum(total) from invoices where billing_state = "CA";
Also provide the number of invoices.
select billing_state, count(*), sum(total) from invoices where billing_state = "CA";