Given the following tables:

write SQL statements to perform the following: 1- list all unfinished(under process) work assignments within a specific department ID. 2-list the names of all employee with their total assignments count that they have 3- show the employee name and warning's status case (null-->"none", "normal", else "high" 4- Get the employee detail with the highest number of warnings 5- get the employees average salaries at each department for only departments that are above the total employee average salaries.

t- Microsoft SQL Server Management Studio Microsoft SQL Server Management Studio Microsoft SQL Server Management Studio