Hey there this is my first post in here i'm a newbie in oracle sql and i'm facing these 4 porblems that i coudn't solve , i wonder if you can help me to get right the sql queries using The UNION [ALL], INTERSECT, MINUS Operators and interrogations in HR Account :
1- 
2- The list of employees and the job of each one of them using a sub query
3- The employees who have a salary > of the salary of the job_id : (job_id=’SA_MAN’) ..
4- The list of employees who have a salary < the average salary of the department they belong to ..
you just need to login to HR account :
I appreciate your help for a newbie in oracle sql
Thank you !