Example To return the minimum and maximum salaries for the employees in each department whose lowest salary is less than $5,000, issue the next statement:

SELECT department_id, MIN(salary), MAX (salary) 
FROM hr.employees 
GROUP BY department_id 
HAVING MIN(salary) < 5000 
ORDER BY department_id