Your question is Max Salary Department Query. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Wipro's workforce planning team needs to identify the department or departments containing the highest-paid employees. Write a PostgreSQL query that returns every department tied for the highest maximum employee salary.
departments with employees, preserving departments even when they have no employees.| Column | Type | Description |
|---|---|---|
| department_idPK | INTEGER | Unique department identifier |
| department_name | VARCHAR(80) | Department name |
| Column | Type | Description |
|---|---|---|
| employee_idPK | INTEGER | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee name |
| department_id | INTEGER | Department assigned to the employee |
| salary | NUMERIC(12,2) | Annual employee salary |