find the names of companies whose main office is in Tokyo.
select name from manufacturers where headquarter = 'Tokyo'
What is the total revenue of these companies?
select sum(revenue) from manufacturers where headquarter = 'Tokyo'
add the revenue of Taiwan companies too.
select sum(revenue) from manufacturers where headquarter = 'Tokyo' or headquarter = 'Taiwan'