select e.emp_no,s3.salary,last_name,first_name from
employees e join salaries s3 on e.emp_no=s3.emp_no
where
(select count(distinct s1.salary)
from salaries s1
where s3.salary<=s1.salary
group by s3.salary
)=2
select e.emp_no,s3.salary,last_name,first_name from
employees e join salaries s3 on e.emp_no=s3.emp_no
where
(select count(distinct s1.salary)
from salaries s1
where s3.salary<=s1.salary
group by s3.salary
)=2