1. You have to write five queries those will be useful for decision making by HR management and/or Financial management using the HR Schema given below. 2. Write SQL for the above five queries

Just write down five queries as HR head.. I will handle the rest.

\( \begin{array}{lll}\text { Schema Title } & \text { Schema Relation } & \\ \text { HR Schema } & \square \text { regions: } & \text { (region_id, region_name) } \\ \text { Student Schema } & \square \text { countries: } & \text { (country_id, country_name, region_id) } \\ & \square \text { locations: } & \text { (location_id, street_address, postal_code, city, state_province, country_id) } \\ & \square \text { departments: } & \text { ( department_id, department_name, manager_id, location_id) } \\ & \square \text { jobs: } & \text { (job_id, job_title, min_salary, max_salary) } \\ & \square \text { employees: } & \text { (employee id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, } \\ & & \text { department_id) } \\ & & \text { (employee } i d, \text { job_id, start_date, end_date, department_id) }\end{array} \) \( \begin{array}{lll}\text { Schema Title } & \text { Schema Relation } & \\ \text { HR Schema } & \square \text { regions: } & \text { (region_id, region_name) } \\ \text { Student Schema } & \square \text { countries: } & \text { (country_id, country_name, region_id) } \\ & \square \text { locations: } & \text { (location_id, street_address, postal_code, city, state_province, country_id) } \\ & \square \text { departments: } & \text { ( department_id, department_name, manager_id, location_id) } \\ & \square \text { jobs: } & \text { (job_id, job_title, min_salary, max_salary) } \\ & \square \text { employees: } & \text { (employee id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct, manager_id, } \\ & & \text { department_id) } \\ & & \text { (employee } i d, \text { job_id, start_date, end_date, department_id) }\end{array} \)