SQL Taskbook Level 3.1
Given a table:
| id | first_name | second_name | salary | start_work_date | department |
| 1 | Aaron | Gold | 4300.00 | 2013-02-10 | React |
| 2 | Marina | Green | 1600.00 | 2022-12-10 | Vue.js |
| 3 | Max | Kamen | 1400.00 | 2020-05-30 | Angular |
| 4 | Catherine | Romish | 700.00 | 2023-10-02 | React |
| 5 | Andrew | Kraplin | 900.00 | 2023-09-01 | Vue.js |
Solve the following tasks for it:
Find the departments where the average length of service of employees exceeds 4 years, and the number of employees in the department is greater than 2. Specify the name of the department, average length of service, and number of employees.
Find employees whose salary is higher than the average salary in their department, but lower than the average salary in the entire company. Include their first names, last names, departments and salaries.
List the departments where the total work experience of employees exceeds 5 years. Specify the department name and total work experience.
Find employees whose last names begin with 'G' and who have more than 6 years of service. Provide their first name, last name, department, and length of service.
