Question

AIM: To perform various DDL and DML commands
Create two relations as follows:
Employee Details (Empld, Name, Managerld, DateOfJoining, City)
EmployeeSalary (Empld, Project, Salary, Bonus)
a) Write an SQL query to fetch the Empld and Name of all the employees working under Manager with id – '986'.
b) Write an SQL query to fetch the different projects available from the Employee Salary table.
c) Write an SQL query to fetch the count of employees working in project "P1'.
d) Write an SQL query to find the maximum, minimum, and average salary of the employees.
e) Write an SQL query to find the employee id whose salary lies in the range of 9000 and 15000.​

Answer 1

Explanation:

hhhhhhhhhhhhhhhhhhhhhhhHhhhhhhh