Database: store_1
Question: How many invoices were billed from Chicago, IL?
SQL:
SELECT COUNT(*) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";