EMPLOYEE TABLE (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO)

DEPT (DEPTNO, DNAME, LOC)

Write the ^{Relational Algebra Expressions} for the following DML queries for the above two tables.

1.Display the name of all the clerks who belong to the Accounting department.

2.Display the name and location of the departments in which the employees earn commission in the descending order of the commission.

3.Calculate the total salary of all the managers of the Sales department.

4.Display the names of salesmen in the Sales department along with the department name and location.

5.Display the employee names along with their managers name.

6.Display the department-wise average salary of the employees.

7.Display the department name and the number of employees in each department for those departments which have more than 5 employees working in them.

Draw the Query Tree for the following queries.

8.Display the employee names, their managers name and the department names for all the employees whose department is located in DALLAS.

9. Display the number of job-tiles in each department arranged in ascending order of the job-tiles [Hint: You have to use DISTINCT, GROUP BY and ORDER BY].