Your question is Highest Manager 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.
Mphasis wants to review compensation levels in its delivery operations. Write a PostgreSQL query to identify the highest salary currently recorded for employees whose job title is exactly Manager.
job_title equals Manager.highest_manager_salary.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's name |
| job_title | VARCHAR(50) | Employee's current job title |
| salary | NUMERIC(10,2) | Annual salary in INR |