This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I was wondering if anyone could give a heads up or maybe show me a partial solution to this question.
Below you will find a task and an attachment of the dataset.
The provided dataset (in attachment) lists employee information including their employee ID as well as the ID of their manager. Every employee has a manager except the CEO whose manager ID value is null. HR wants to understand the reporting structure hierarchy within the company. How many employees have 3 reporting levels between themselves and the CEO not including their own level and that of the CEO?