Employees Earning Above Department Average

Problem Statement

Problem Description You are given a database containing employee information and their respective departments. Write an SQL query to identify all employees whose salary is greater than or equal to the average salary within their own department. Schema Department Table Column Name Data Type Description departmentId INTEGER Primary Key. Unique identifier for the department. departmentName VARCHAR Name of the department. Employee Table Column Name Data Type Description employeeId INTEGER Primary Key. Unique identifier for the employee. departmentId INTEGER Foreign Key referencing Department.departmentId . employeeName VARCHAR Name of the employee. location VARCHAR Work location of the employee. salary INTEGER Salary of the employee. Required Output Your query should return a result set with the following columns: employeeId employeeName salary Ordering: The final result must be ordered by employeeId in ascending order. Constraints or Notes This environment uses SQLite . Ensure your query