Given Three Tables (hr.Employees, hr.Departments, and hr.jobs). For employees are working in department no 90 or departm

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

Given Three Tables (hr.Employees, hr.Departments, and hr.jobs). For employees are working in department no 90 or departm

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply