Skip to content

Practice The Number of Employees Which Report to Each Employee

Read the task, work through the examples, and check your approach against the constraints. Use the original LeetCode task for coding and submissions.

Easy#1731
LeetCode Problem

The Number of Employees Which Report to Each Employee

Problem Statement

Tables: Employees(employee_id INT, name VARCHAR, reports_to INT, age INT). Employees.employee_id is unique. A null reports_to means no manager. Return employee_id, name, reports_count and average_age for employees with at least one direct report. Count only employees whose reports_to matches that manager and round their mean age to the nearest integer. Order by employee_id ascending.

Source: The Number of Employees Which Report to Each Employee on LeetCode. Use the original task for its coding environment and submissions.

Examples

# Example 1

Input
Employees table: +-------------+---------+------------+-----+ | employee_id | name    | reports_to | age | +-------------+---------+------------+-----+ | 9           | Hercy   | null       | 43  | | 6           | Alice   | 9          | 41  | | 4           | Bob     | 9          | 36  | | 2           | Winston | null       | 37  | +-------------+---------+------------+-----+
Output
+-------------+-------+---------------+-------------+ | employee_id | name  | reports_count | average_age | +-------------+-------+---------------+-------------+ | 9           | Hercy | 2             | 39          | +-------------+-------+---------------+-------------+

# Example 2

Input
Employees table: +-------------+---------+------------+-----+ | employee_id | name    | reports_to | age | |-------------|---------|------------|-----| | 1           | Michael | null       | 45  | | 2           | Alice   | 1          | 38  | | 3           | Bob     | 1          | 42  | | 4           | Charlie | 2          | 34  | | 5           | David   | 2          | 40  | | 6           | Eve     | 3          | 37  | | 7           | Frank   | null       | 50  | | 8           | Grace   | null       | 48  | +-------------+---------+------------+-----+
Output
+-------------+---------+---------------+-------------+ | employee_id | name    | reports_count | average_age | | ----------- | ------- | ------------- | ----------- | | 1           | Michael | 2             | 40          | | 2           | Alice   | 2             | 37          | | 3           | Bob     | 1             | 37          | +-------------+---------+---------------+-------------+

Related LeetCode Problems

Practice more problems similar to The Number of Employees Which Report to Each Employee.

Review your practice with PhantomCodeAI

After trying the problem yourself, use the app to discuss your approach, complexity, and edge cases.