SELECT DEPARTMENT_NAME, count( distinct JOB_ID) FROM EMPLOYEES JOIN departments USING (department_id) group by DEPARTMENT_NAME HAVING count( distinct JOB_ID)>'1';

cevap buymuş