Overall Project overview, Basic SQL (window function, max salary and joins) and pyspark (joins, read and write into delta and other format).
For the SQL portion, write a PostgreSQL query using the provided employee, department, project, and assignment data. Return employees whose salary equals the maximum salary in their department, including employees with no assigned projects.
Output
- One row per qualifying employee with
department_name, employee_name, salary, department_max_salary, salary_rank, and project_count.
- Order by department name, then employee name.
