sql_query
SELECT full_name FROM employees e1 WHERE salary > (SELECT AVG(salary) FROM employees e2 WHERE e2.department_id = e1.department_id) ORDER BY full_name
schema_ddl
CREATE TABLE employees (id INTEGER PRIMARY KEY, full_name TEXT NOT NULL, department_id INTEGER NOT NULL, salary INTEGER NOT NULL);
fixture_data
INSERT INTO employees (id, full_name, department_id, salary) VALUES (1, 'Priya Natarajan', 1, 118000), (2, 'Marcus Webb', 2, 92000), (3, 'Yuki Tanaka', 1, 104000), (4, 'Elena Petrova', 1, 131000), (5, 'Dario Conti', 3, 87000), (6, 'Sofia Reyes', 2, 98500);
query_categorysubquery
expected_result
[
[
"Elena Petrova"
],
[
"Priya Natarajan"
],
[
"Sofia Reyes"
]
]task_descriptionList the full names of employees who earn more than the average salary within their own department.