Write SQL/PySpark to find employees whose salary is greater than the average salary. Asked in the Round 2 stage.
Use a single employees table for the SQL version.
employee_id, employee_name, salarysalary descending, then employee_id ascending| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee full name |
| department | VARCHAR(100) | Employee department |
| salary | NUMERIC(12,2) | Current annual salary |