Quantiphi’s workforce reporting team needs a simple compensation metric for internal analysis. The result will be used to identify the highest recorded salary in the employee dataset.
Write a PostgreSQL query that returns the maximum non-NULL salary from the employees table.
MAX aggregate function on the salary column.maximum_salary.| Column | Type | Description |
|---|---|---|
| employee_idPK | INTEGER | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee’s full name |
| department | VARCHAR(50) | Employee’s department |
| salary | NUMERIC(10,2) | Annual salary, which may be unavailable |