select e.emp_no , s.salary
from employees e join salaries s
on e.emp_no = s.emp_no
and s.from_date = e.hire_date
order by e.emp_no desc
;
select e.emp_no , s.salary
from employees e join salaries s
on e.emp_no = s.emp_no
and s.from_date = e.hire_date
order by e.emp_no desc
;