SELECT billing_state ,  COUNT(*) FROM invoices WHERE billing_country  =  "USA" GROUP BY billing_state ORDER BY COUNT(*) DESC LIMIT 1;
What are the states with the most invoices?
SELECT billing_state , COUNT ( * ) FROM invoices WHERE billing_country = `` USA '' GROUP BY billing_state ORDER BY COUNT ( * ) DESC LIMIT 1 ;
select billing_state , count ( * ) from invoices where billing_country = value group by billing_state order by count ( * ) desc limit value
What are the states with the most invoices ?