Write the following queries in SQL using the Employees schema.

The employee schema is as follows:

3.1 Find all the distinct titles. The result should be following:

3.2 Find the average salaries per the title. The result should be the following:

3.3 Find the number of employees for each department. The result should be the following:

3.4. Find the number of Male/Female employees for each department. The result should be the following:

3.5. Find the highest and lowest salary for each department. The result should be the following:

Eemployees Tales ] departments Columns dept_no dept-name Indexes Foreign Keys Triggers dept_emp Columns emp_no dept_no from_date todate Indexes Foreign Keys Triggers dept manager Columns emp_no dept-no from_date to date