Your question is SQL Query for Max Salary. Start with the requirements and the one table 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.
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 |