Identifying Senior Management Tiers
Given a table
employees with columns emp_id, manager_id, and manager_name, define a 'Senior Manager' as an employee who manages at least one individual who is himself/herself a manager, but does not manage anyone who qualifies as a Senior Manager. Write a SQL query to return the name of every Senior Manager and the total count of their direct reports. If an employee reports to multiple managers, they should be counted as a report for each. Sort the results by the report count in descending order. Note: A manager is any employee who has at least one direct report.PostgreSQLCTESubquerySet TheoryAggregations
00