Given Three Tables (hr.Employees, hr.Departments, and hr.jobs). For employees are working in department no 90 or departm
Posted: Fri May 20, 2022 10:49 am
Given Three Tables (hr.Employees, hr.Departments,
and hr.jobs).
For employees are working in department no 90 or
department 80, Retrieve a list of Employee id, last Name, email and
Salary.
retrieve list of employees First names, salaries and
their job titles.
For Employees who get salary between 6000 and 17000,
Retrieve a list of their First name and Department
names.
For each job that has more than 2 employees, retrieve
its job_id and how many employees dedicated to
it.
and hr.jobs).
For employees are working in department no 90 or
department 80, Retrieve a list of Employee id, last Name, email and
Salary.
retrieve list of employees First names, salaries and
their job titles.
For Employees who get salary between 6000 and 17000,
Retrieve a list of their First name and Department
names.
For each job that has more than 2 employees, retrieve
its job_id and how many employees dedicated to
it.