Task: Text to Code
Input (English): Step 1: For each row in company table, find the corresponding rows in employment table.
Step 2: find Name, Year_working of the results of step 1 ordered descending by Year_working
Output (English): SELECT T1.Name , T2.Year_working FROM company AS T1 JOIN employment AS T2 ON T1.Company_ID = T2.Company_ID ORDER BY T2.Year_working Desc