All People Report to the Given Manager
[]
['Create table If Not Exists Employees (employee_id int, employee_name varchar(30), manager_id int)', 'Truncate table Employees', "insert into Employees (employee_id, employee_name, manager_id) values ('1', 'Boss', '1')", "insert into Employees (employee_id, employee_name, manager_id) values ('3', 'Alice', '3')", "insert into Employees (employee_id, employee_name, manager_id) values ('2', 'Bob', '1')", "insert into Employees (employee_id, employee_name, manager_id) values ('4', 'Daniel', '2')", "insert into Employees (employee_id, employee_name, manager_id) values ('7', 'Luis', '4')", "insert into Employees (employee_id, employee_name, manager_id) values ('8', 'John', '3')", "insert into Employees (employee_id, employee_name, manager_id) values ('9', 'Angela', '8')", "insert into Employees (employee_id, employee_name, manager_id) values ('77', 'Robert', '1')"]
{"mysql": ["Create table If Not Exists Employees (employee_id int, employee_name varchar(30), manager_id int)"], "mssql": ["Create table Employees (employee_id int, employee_name varchar(30), manager_id int)"], "oraclesql": ["Create table Employees (employee_id int, employee_name varchar(30), manager_id int)"], "database": true, "name": "find_reporting_people", "pythondata": ["Employees = pd.DataFrame([], columns=['employee_id', 'employee_name', 'manager_id']).astype({'employee_id':'Int64', 'employee_name':'object', 'manager_id':'Int64'})"], "postgresql": ["\nCreate table If Not Exists Employees (employee_id int, employee_name varchar(30), manager_id int)"], "database_schema": {"Employees": {"employee_id": "INT", "employee_name": "VARCHAR(30)", "manager_id": "INT"}}}
{"mysql": ["MySQL", "<p><code>MySQL 8.0</code>.</p>"], "mssql": ["MS SQL Server", "<p><code>mssql server 2019</code>.</p>"], "oraclesql": ["Oracle", "<p><code>Oracle Sql 11.2</code>.</p>"], "pythondata": ["Pandas", "<p>Python 3.10 with Pandas 2.2.2 and NumPy 1.26.4</p>"], "postgresql": ["PostgreSQL", "<p>PostgreSQL 16</p>"]}
['Database']