SQL-2

//5
select * from HR.Employees where Hr.Employees.Salary > 2000 and HR.Employees.JOB_ID not in (select job_id from HR.Jobs where job_title='Stock Manager' or job_title='Purchasing Manager');
//7
select * from HR.Employees where (Hr.Employees.Commission_Pct*Hr.Employees.Salary) is null or  (Hr.Employees.Commission_Pct*Hr.Employees.Salary) <100;
//9
select First_name||Last_name,hire_date from Hr.Employees order by hr.employees.hire_date;
//11
select * from Hr.Employees em where em.hire_date < (select hire_date from Hr.Employees em2 where em.manager_id=em2.employee_id);
//13
select * from Hr.Employees em  right join Hr.Departments de on(em.department_id=de.department_id);
//15
select em.employee_id,em.first_name||em.last_name,de.department_name,jo.job_title from Hr.Employees em ,Hr.Departments de,Hr.Jobs jo where(em.department_id=de.department_id and em.job_id =jo.job_id);
//17
select * from Hr.Employees em where em.salary > (select salary from Hr.Employees em2 where em2.employee_id=100);
//19
select max(salary),em.job_id,em.department_id from Hr.Employees em group by (em.job_id,em.department_id)
//20
select count(*),avg(salary) from HR.Employees group by (HR.Employees.DEPARTMENT_ID);
//21
select count(*),avg(salary) from HR.Employees group by (HR.Employees.JOB_ID);
//23
select * from Hr.Jobs jo where jo.min_salary > 5000;
//25