Names of headquarters that have at least two companies?
select headquarters from company group by headquarters having count ( * ) > = 2
What is tbe name of the company in china?
select name from company where headquarters = "China"
What industry does petrochina belong to?
select industry from company where name = "PetroChina"