List total amount of  invoice from Chicago, IL.
SELECT sum(total) FROM invoices WHERE billing_city  =  "Chicago" AND billing_state  =  "IL";
total amount of invoice refers to SUM(total); from Chicago, IL refers to WHERE billing_city = 'Chicago' AND billing_state = 'IL';