select t1.emp_no, t2.s from employees t1 inner join (select emp_no, min(salary) s from salaries group by emp_no) t2 on t1.emp_no=t2.emp_no order by t1.emp_no desc;