(Solved): Consider the following relational schema: Write SQL statement for the followi ...

???????

Consider the following relational schema: Write SQL statement for the following queries: a) Display Employee names of Administration department ordered by their salary. b) Write a DML statement that will update the salary for employees in the administration department by ten percent. Ex. if salary was 30000 it will be 33000,40000 will be 440000,50000 will be 55000 and so on. c) Display Department Number, Department Name, and Number of Employees for all departments which have average salary greater than 40000 . d) Display Department Number, Department Name, and Number of Employees for all departments which have average salary greater than administration department average salary. e) Display Department Number, Department Name, and Number of Employees for the departments which have the largest number of employees. f) Display Employees getting more salary than their supervisor. g) Display Name of employee(s) who earn maximum salary in their organization. Submission Submit a report which includes the solution for the above exercise including the query and the SQL Data result