Query design by referring the following scenario.Scenariocompany has a huge database to handle their employees’ details.Most of the details regarding the employee activities and department details are stored in Employeestable and Departments table. Write the appropriate query to support the manager to complete thefollowing: 6. Using Employees table with sub-queries,• Display the Department_Id, job_id and maximum Salary. Restrict the output for theemployee_id, which is greater than to any employee_id from employees, whose Salary is morethan or equal to 80000 and job_id is the same as to any of the job_id from employees, whoseHire_date is after 01-January-1989.Group it by department_id and job_id, whose maximum salary is more than or equal to 10000.

A query is created using the following syntax having all the clauses required in the given question.…

Answered: 6. Using Employees table with…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

Query design by referring the following scenario.
Scenario
company has a huge database to handle their employees’ details.
Most of the details regarding the employee activities and department details are stored in Employees
table and Departments table. Write the appropriate query to support the manager to complete the
following:

6. Using Employees table with sub-queries,
• Display the Department_Id, job_id and maximum Salary. Restrict the output for the
employee_id, which is greater than to any employee_id from employees, whose Salary is more
than or equal to 80000 and job_id is the same as to any of the job_id from employees, whose
Hire_date is after 01-January-1989.
Group it by department_id and job_id, whose maximum salary is more than or equal to 10000.

Expert Solution

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions