Problem Statement

Employees Above Their Department's Average Salary Consider the SQLite table exam_employees3 : | EmpID | Name | Department | Salary | JoiningDate | |------:|---------|------------|---------:|---------------------| | 1 | Alice | HR | 50000.00 | 2020-01-15 00:00:00 | | 2 | Bob | IT | 75000.00 | 2019-03-25 00:00:00 | | 3 | Charlie | Finance | 65000.00 | 2018-06-10 00:00:00 | | 4 | Diana | IT | 80000.00 | 2021-05-01 00:00:00 | | 5 | Edward | HR | 55000.00 | 2020-09-12 00:00:00 | Write a SQL query that returns every employee whose Salary is strictly greater than the average salary of the employee's own Department . Return exactly these columns, in this order: Name , Department , Salary Return the matching rows in ascending EmpID order. Display Salary with exactly two digits after the decimal point. Do not include a header row. For the table above, the department averages are: HR: 52500.00 IT: 77500.00 Finance: 65000.00 Therefore the expected output is: Diana|IT|80000.00 Edward|HR|5