where is the Headquarter of Sony?
select headquarter from manufacturers where name = "Sony"
how much is Creative Labs revenue?
select revenue from manufacturers where name = "Creative Labs"
what is the name of the manufacturer whose headquarter is in Los Angeles?
select name from manufacturers where headquarter = "Los Angeles"
name the  manufacturer with the least revenue
select name from manufacturers order by revenue limit 1