Supervision Employee Department Dnumber +- ------ Works-fer---- - - - - - PK Ssn Dname Fname Minit Lname Sex Bdate Address Salary FK1 Dnumber FK2 SuperSSN Works on PK.FK2 Pnumber *PK,FK1 Ssn HE Worker Controls Hours Project Pnumber od PK Project HA FK1 Plocation Dnumber Pname All the queries must be processed in a single command. (A1) Find employees' names whose salaries are over 28000 and who work for the research department. (A2) For each project, find the department name which controls the project. Sort the output by project name. (A3) Find all employees whose salary is the same as Joyce English's. (A4) Find the average, the largest, and the smallest salary for each department. Print both department names and department numbers. (A5) For each department, find the names of all the projects controlled by the department. Sort the output by each department name and project name. (A6) Show the first name, last name, and the age of each employee who works on projects where the project names begin with 'P'. (Note: you are supposed to derive the integer value of "age." Use TRUC function to produce the integer value of the ages.)