Formulate Relational Algebra queries:

Use the schema from Case Company to formulate your queries EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex Salary Superssn Dno DEPARTMENT DnameDnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS DnumberDlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_nameS Bdate Relationship Query 22 Retrieve the total number of employees in the Research department. Query 23 Count the number of distinct salary values in the database. Query 24 For each department, retrieve the department number, the number of employees in the department, and their average salary Query 25 For each project, retrieve the project number, the project name, and the number of employees who work on that project. Query 26 For each project on which more than two employees work, retrieve the project number, the project name, and the number of employees who work on the project. Query 27 For each project, retrieve the project number, the project name, and the number of employees from department 5 who work on the project. Query 28 For each department that has more than five employees, retrieve the department number and the number of its employees who are making more than $40,000