use SQL to develop and execute the following queries:1- Display the rank value and the average salary of employees per rank.2- Display names and ids of employees from the "Human Resources" department.3- Display the average salary of employees working in the "Marketing" department. Give an appropriate name to the output Consider the following relations for a company:Department (Did: integer, Dname: string, location: string)Employee (Eid: integer, Ename: string, Erank: integer, salary: real, DepartmentlID, integer)Project (Pid: integer, DepartmentID: integer, Pname: string, budget: real, start year: integer)The "DepartmentID" fields in both Employee and Project are foreign keys referencing the "Did" field of theDepartment table.

Answered: use SQL to develop and execute the…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

use SQL to develop and execute the following queries: 1- Display the rank value and the average salary of employees per rank. 2- Display names and ids of employees from the "Human Resources" department. 3- Display the average salary of employees working in the "Marketing" department. Give an appropriate name to the output