[يسار]please i want some one to solve this problem to me

i want to make this reports
"The HR department needs a list of department IDs for departments that do not contain the job ID ST_CLERK. Use set operators to create this report


"The HR department needs a list of countries that have no departments located in them. Display the country ID and the name of the countries. Use set operators to create this report[/يسار]

"The HR department needs a report with the following specifications:

Last name and department ID of all the employees from the EMPLOYEES table, regardless of whether or not they belong to a department
Department ID and department name of all the departments from the DEPARTMENTS table, regardless of whether or not they have employees working in them
Write a compound query to accomplish this

.

جواب السؤال الأول

 select department_id,job_id from employees
minus
 select department_id ,job_id from employees where job_id='ST_CLERK';

and what about the second question please