Task: Text to Code
Input (English): List total amount of  invoice from Chicago, IL.
Output (English): SELECT sum(total) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL"