What is the lowest salary across all employees?
select min(salary) from employees
Which employees make more than that?
select * from employees where salary > (select min(salary) from employees)
Of those, which make less than 2500?
select * from employees where salary between (select min(salary) from employees) and 2500