CREATE TABLE invoices (total INT, billing_city VARCHAR, billing_state VARCHAR)

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