Database: store_1
Question: List the number of invoices from Chicago, IL.
SQL:
SELECT COUNT(*) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";