I am getting the error message "sql command not properly ended" when I try to run the following query. I am using Oracle 10g XE. I do not understand what I am missing in this statement. Your help is appreciated.
select e.last_name,e.department_id,j.job_id,j.job_title,MIN(e.salary),MAX(e.salary) from employees e, jobs j on e.job_id = j.job_id group by e.department_id having e.department_id in (50,60) order by e.job_id,e.last_name;