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
Show 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
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
Show names of companies and that of employees in descending order of number of years working for that employee .