Discuss the below:
Q1. Database Tables
TABLE: Employees
Job_title_code
Social_security_number
Last_name
First_name
Address
City
State
Zip_code
Telephone_area_code
Telephone_number
Email_address
Hire_date
Salary
TABLE: Job_title
Job_title_code
Job_title
Exempt_non_exempt_status
Minimum_salary
Maximum_salary
Q2. Write SQL statements to:
A. Calculate the average salary for all employees.
B. Calculate the maximum salary for exempt employees and the maximum salary for non-exempt employees.
C. Calculate the maximum salary for all employees.
D. Calculate the minimum salary for exempt employees and the maximum salary for non-exempt employees.
E. Calculate the minimum salary for all employees.