úÎaÿB      !"#$%&'()*+,-./0123456789:;<=>?@A         !all employees " all clerks #%all clerks with salary at least 1000 $%all employees in research department %&'(A recursive query: *Compute the total salary for each manager ,and the total set of employees he conducts. !"#$%&'(!"#$%&'(!"#$%&'()all employees * all clerks +%all clerks with salary at least 1000 ,%all employees in research department -.*names of all employees and their managers %if the employee has a manager so far /+names of all employees and their managers; 7if the employee has no manager, return an empty string 02names of managers that have at least one employee 1)managers that have at least one employee 2Amanagers that have at least one employee, sorted by their names. 3%maximum salary amongst all employees 41employee with maximum salary without a back-join 5$employees grouped by their managers implemented with a sub-query 6$employees grouped by their managers implemented with a GROUP BY 7"average salary in each department 8manager with most employees 9A recursive query: *Compute the total salary for each manager ,and the total set of employees he conducts. :)*+,-./0123456789:)*+,-./0123456789:)*+,-./0123456789:;<=>?@;<=>?@;<=>?@;<=>?@AAAAB      !!"#$%&'()*+$%&'(,-./01234567+89:;<=>?database-study-0.0.1QueryCompanyExample.RelationalAlgebraExample.QueryMonadTableExample.UpdateMonad showTablecrossjoinaverage averageIntgroupBy DeptNoFielddeptnoEmpempnoenamejobmgrsal deptnoEmpEmpNoJob PresidentAnalystManagerSalesmanClerkDept deptnoDeptdnamelocDeptNodeptemp employeesclerks richClerks researchers researchers0 hierarchy hierarchyFast teamSalariesmanagers managers0 realManagersrealManagersFullrealManagersSortedFull maximumSalaryrichestEmployeeteamsteams0averageSalariesInDepartmentsmanagerOfLargestTeam teamSalaries0createfrominsertdeleteupdate updateWheremain