Analysis of workforce data, performance, and engagement. Datasets: Employees Table Column Name Data Type Description employee_id Integer Unique identifier for each employee department_id Integer Identifier for the employee's department job_level String The level of the job (e.g., Junior, Mid-level, Senior) tenure_in_level Integer Years in job level tenure Integer Years with the company Performance Table Column Name Data Type Description employee_id Integer Unique identifier for each employee year Integer Performance review year performance_rating Integer Rating on a 1-5 scale Engagement Survey Table Column Name Data Type Description employee_id Integer Unique identifier for each employee year Integer Survey year engagement_score Integer Score on a 1-10 scale All employees might not have an engagement score

Task: 1. Write a SQL query to show average score across the company.

2. Construct a SQL query to identify the top 5 departments with the highest average engagement score among employees with a performance rating of 4 or above in 2023.

3. Only employees who responded to the survey will have a score. Write a SQL query to show the top 5 departments with least participation rates in year 2022 and year 2023.

4. Create a SQL query to rank each department based on how much above or below they score compared to the average company score (Hint: Rank based on Company Avg Score - Department Avg Score)