SELECT j.job_title, CONCAT(e.first name. e.last name) AS employee_name (J.max salary - e.salary) AS salary difference FROM employees e JOIN jobs) e.job_id=j.job_id;