CEO Subordinate Hierarchy
[]
['Create table if not exists employees(employee_id int, employee_name varchar(100), manager_id int, salary int)', 'Truncate table Employees', "insert into Employees (employee_id, employee_name, manager_id, salary) values ('1', 'Alice', NULL, '150000')", "insert into Employees (employee_id, employee_name, manager_id, salary) values ('2', 'Bob', '1', '120000')", "insert into Employees (employee_id, employee_name, manager_id, salary) values ('3', 'Charlie', '1', '110000')", "insert into Employees (employee_id, employee_name, manager_id, salary) values ('4', 'David', '2', '105000')", "insert into Employees (employee_id, employee_name, manager_id, salary) values ('5', 'Eve', '2', '100000')", "insert into Employees (employee_id, employee_name, manager_id, salary) values ('6', 'Frank', '3', '95000')", "insert into Employees (employee_id, employee_name, manager_id, salary) values ('7', 'Grace', '3', '98000')", "insert into Employees (employee_id, employee_name, manager_id, salary) values ('8', 'Helen', '5', '90000')"]
{"mysql": ["Create table if not exists employees(employee_id int, employee_name varchar(100), manager_id int, salary int)"], "mssql": ["Create table employees(employee_id int, employee_name varchar(100), manager_id int, salary int)"], "oraclesql": ["Create table employees(employee_id NUMBER, employee_name varchar2(100), manager_id NUMBER, salary NUMBER)"], "database": true, "name": "find_subordinates", "manual": false, "postgresql": ["CREATE TABLE IF NOT EXISTS employees (\n    employee_id INT,\n    employee_name VARCHAR(100),\n    manager_id INT,\n    salary INT\n);\n"], "pythondata": ["Employees = pd.DataFrame(columns=['employee_id', 'employee_name', 'manager_id', 'salary']).astype({\n    'employee_id': pd.Int64Dtype(),\n    'employee_name': 'str',\n    'manager_id': pd.Int64Dtype(),\n    'salary': pd.Int64Dtype()\n})"], "database_schema": {"employees": {"employee_id": "INT", "employee_name": "VARCHAR(100)", "manager_id": "INT", "salary": "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']