Your question is Highest Salary Query. 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.
Persistent Systems needs a quick salary summary for its engineering workforce. Write a PostgreSQL query that returns the highest non-null salary recorded in the employees table.
salary.highest_salary.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| name | VARCHAR(100) | Employee's full name |
| salary | NUMERIC(10,2) | Annual employee salary |