(Solved) : Consider Following Three Relations Manager Name Address Specialization Salary Employee Nam Q30386319 . . . .

Consider the following three relations:

Manager(name, address, specialization, salary)

Employee(name, address, rank, salary)

Project (proj_num, emp_name, manager_name, duration)

Write the SQL queries corresponding to the followingquestions.

a. Find the number of different employees who are assigned toprojects.

b. Find the managers’ average salary.

c. List the name and number of projects supervised by eachmanager.

d. Show the names and salaries of managers who superviseemployees of rank “beginner” in ascending order of salary (use asubquery).

e. Show the names and salaries of managers who superviseemployees of rank “beginner” in descending order of salary (do notuse a subquery).

f. Show the names and salaries of supervisors who supervise morethan 20 employees.

Expert

OR

 

PayPal Gateway not configured

OR

 

PayPal Gateway not configured