You are a database administrator analyzing a company's organizational hierarchy stored in a SQLite database…
You are a database administrator analyzing a company's organizational hierarchy stored in a SQLite database…: a task in repo2rlenv-tmax (Harbor dataset). The database has this schema: sql CREATE TABLE employees ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, title TEXT NOT NULL, department TEXT NOT…
The task
The database has this schema: ```sql CREATE TABLE employees ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, title TEXT NOT NULL, department TEXT NOT NULL, manager_id INTEGER REFERENCES employees(id), salary REAL NOT NULL, hire_date TEXT NOT NULL ); ```
Part of FineEnvs/repo2rlenv-tmax.