select
es.emp_no
,max(ss.salary)
,es.last_name
,es.first_name
from employees es 
left join salaries ss
on es.emp_no = ss.emp_no
where ss.salary < 
(
    select
    max(salary)
    from salaries
)