The ZooZoo company has decided to do some cost-cutting in the company due to some losses...

 

Transcribed Image Text:

The ZooZoo company has decided to do some cost-cutting in the company due to some losses in the past year. To go ahead with the process they decided to find the replacements of employees with higher salaries in order to hire new employees with lesser salaries. Mark, the CEO, needs your help in determining the salary, name, and department_id of employees having the highest salary in each department. EMPLOYEE ie inti name learchar) age lint) ROLES DEPARTMENT city lvarchari dint ja linti salary (int) role, name (varchar) nama (varchar) ender (versher mangeid lint) department d(int | role_dlint) The ZooZoo company has decided to do some cost-cutting in the company due to some losses in the past year. To go ahead with the process they decided to find the replacements of employees with higher salaries in order to hire new employees with lesser salaries. Mark, the CEO, needs your help in determining the salary, name, and department_id of employees having the highest salary in each department. EMPLOYEE ie inti name learchar) age lint) ROLES DEPARTMENT city lvarchari dint ja linti salary (int) role, name (varchar) nama (varchar) ender (versher mangeid lint) department d(int | role_dlint)

Answer rating: 100% (QA)

First we will be writing a sql query to create a shorter table with less attributes so we can focus ... View the full answer