Schema: CREATE TABLE manufacturers (revenue INTEGER, Headquarter VARCHAR)
Question: What is the total revenue of all companies whose main office is at Tokyo or Taiwan?
SQL: SELECT SUM(revenue) FROM manufacturers WHERE Headquarter = 'Tokyo' OR Headquarter = 'Taiwan'