Given the following tables: 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.

\begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Assignment } \\ \hline Aid \\ \hline Adate \\ \hline Aduration \\ \hline Afinish \\ \hline Adesc \\ \hline Stateid \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Employee } \\ \hline Eid \\ \hline Esal \\ \hline Eaddress \\ \hline Ephone \\ \hline Adesc \\ \hline MaritalStatus \\ \hline Efname \\ \hline Emid \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ Department } \\ \hline Did \\ \hline Daddress \\ \hline Dname \\ \hline Dphone \\ \hline \end{tabular}