WRITE SQL QUERIES FOR THE FOLLOWING:

Modify the previous query to show only the current manager of each department. A manager is a current manager if the to date column is equal to "9999-01-01".

What is the average current salary for each position?

How many Assistant Engineers currently earn more than the average salary of all current employees?

employees emp_no* birth_date* first_name* last_name* gender* hire_date* salaries emp_no* salary* from_date" to_date* titles dept_emp emp_no dept_no* from_date* to_date* dept_manager dept_no* emp_no* from_date* to_date* emp_no* title* from_date* to_date departments dept_no* dept_name*