SELECT surname, job, salary, jobs.min_salary AS job_min_salary, jobs.max_salary AS job_max_salary
FROM employees
INNER JOIN jobs
ON employees.job = jobs.name
ORDER BY surname;