WRITE THE SQL QUERIES NEEDED ---

show all identifiers of departments that have more than 40000 employees.

Create a stored procedure to show the difference in the average salaries for males and females?

Create a stored procedure to show first name, last name, salary and title of all employees with the salary between 38000 and 39000. Sort them by the salary. You want to present only the current job title.

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*