Available question text
Given an Employees table, identify employees who are managers (have at least one direct report) and return each manager's id, name, the count of direct reports, and the reports' average age rounded to the nearest integer, ordered by employee_id. This is solved by aggregating (count and avg+round) over rows grouped by the manager id—typically via a GROUP BY on reports_to or a self-join.
Related questions
Continue with questions that share topics or the same question type.
- A question around around array and number and SQL about counting employee salary and showing them in descending order
Coding
- Count Number of Rectangles Containing Each Point
Coding
- Find Total Time Spent by Each Employee
Coding
- Given an integer array nums, find the contiguous subarray (containing at least one number) which has the largest sum and return its sum. Walk through Kadane's algorithm and explain the O(n) approach.
Coding
Sources · 1 reference
These records explain where the question appears. A company tag or candidate report does not guarantee a future interview question.
Hello Interview · 1 record
No company association
Leetcode 1731. The Number of Employees Which Report to Each Employee
Reported date not specified · 0 source reports
Source snapshot: Nov 12, 2026
View source