Question

Consider the following two tables:

Table – EmployeeInformations                                  Table – EmployeeSalary

EmpId	Name	ManagerId	DateOfJoining
121	Ali	321	01/31/2014
321	Raed	986	01/30/2015
421	Khaled	876	27/11/2016

EmpId	Project	Salary
121	P1	8000
321	P2	1000
421	P1	12000

1. Write a SQL query to find the names of all employees having salary greater than or equal to 5000 and less than or equal 10000?
2. Write a SQL query to find all employees from the " EmployeeInformations " table, sorted by the " ManagerId " column:
3. Write a SQL query to find the average salary of all employees
4. Write a SQL query to find all employee records from EmployeeInformations table who have a salary record in EmployeeSalary table.

Answer 1

a)Write a SQL query to find the names of all employees having salary greater than or equal to 5000 and less than or equal 10000?
answer)
SELECT Name FROM EmployeeInformations,EmployeeSalary WHERE EmployeeInformations.EmpId=EmployeeSalary.EmpId AND
Salary>=5000 OR Salary<=10000;
b) Write a SQL query to find all employees from the " EmployeeInformations " table, sorted by the " ManagerId
answer)SELECT EmpId,Name FROM EmployeeInformation ORDER BY ManageId ASC;
c)Write a SQL query to find the average salary of all employees
SELECT AVG(Salary) FROM EmployeeInformations,EmployeeSalary WHERE EmployeeInformations.EmpId=EmployeeSalary.EmpId;
d)Write a SQL query to find all employee records from EmployeeInformations table who have a salary record in EmployeeSalary table.
SELECT EmployeeInformations.EmpId,EmployeeInformations.Name,EmployeeInformations.ManagerId,EmployeeInformations.DateOfJoining FROM EmployeeInformations,EmployeeSalary WHERE EmployeeInformations.EmpId=EmployeeSalary.EmpId;