Tell me the people working in HSBC.
select 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 where t3.name = "HSBC"
How many are there?
select count(*) 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 where t3.name = "HSBC"
What are the names of the companies and that of the 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