Show the company name and the main industry for all companies.
select company, main_industry from company
Show the results only for those whose headquarters are not from USA.
select company, main_industry from company where headquarters != 'USA'