Using the database, tables, and data, write SQL statements to:
1 Calculate the average salary for employees for each state.
2 Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
3 Calculate the maximum salary for all employees whose hire_date is between two dates.
4 Calculate the maximum salary for employees within each job class
5 Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
6 Calculate the total salary for employees separated by gender within each job class
7 Determine the oldest and youngest employees and provide the age for each category.
8 Determine what percent of the largest salary is used for the total payroll in the company.
Attachment:- sql.txt