Database: store_1
Question: What are the total amount of money in the invoices billed from Chicago, Illinois?
SQL:
SELECT sum(total) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";