Скачать или смотреть SQL - Use of subquery with group by

Context:

GlobalTech Solutions is a multinational company with thousands of employees spread across various departments.

The company's Human Resources (HR) department maintains a comprehensive database to manage employee information, including personal details, employment history, and departmental affiliations.

The HR department wants to identify key managers who oversee a significant number of employees. Understanding which managers are handling larger teams can assist in evaluating management effectiveness, allocating resources, and making organizational decisions.

Problem Statement:

You need to write a SQL query to find the "full_name" (first_name and last_name, separated by space) of managers who oversee four or more employees.

The result should be ordered by full_name, lexicographically.
The column manager_id in the employees table represents the employee_id of the manager.

Sample Explanation:

In the sample data, we have 2 manager IDs 101 and 102. But only the manager with id 101 manages 4 or more employees.
Hence, we return the full_name (i.e., Neena Kochhar) of manager 101.