List first_name, dept_id and salary of employees who earn more than the average of their own department.
7 rows with columns first_name, dept_id, salary — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Anita | 1 | 250000 |
| 2 | Rahul | 1 | 180000 |
| 3 | Priya | 1 | 140000 |
Run your code to see the output here.