Show the name of the company with company_id 1.0?
select name from company where company_id = 1.0
Show the names of companies and that of employees in descending order of number of years working for that employee?
select t3.name, t2.name from employment as t1 join people as t2 on t1.people_id = t2.people_id join company as t3 on t1.company_id = t3.company_id order by t1.year_working
yes
select company_id from company where headquarters = "USA"