Using the tables above, write and execute SQL for the following queries. Save each successful command in the spool file.

1.The name (in ascending order), starting salary and department id of each employee within a descending order of department ids.

2.Give the number of employees for each of the pension schemes offered by the company. The result listing should include the name of each scheme and the corresponding number of employees who join the scheme.

3.List the id and name of each employee along with his/her managers name.

4.Give the total number of employees who are not a manager but currently receive an annual salary of over 30,000.

5.List employees whose surnames begin with S and whose employee ids begin with either E1 or E3 along with the departments in which they work. The result listing should include the ids, names of the employees and the names of their departments.