Your question is Top 3 Highest Paid Employees. 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.
Jio's workforce analytics team needs a simple report showing the three employees with the highest annual salaries. Write a PostgreSQL query using the employees table.
NULL salaries as unranked, and use employee ID as a deterministic tie-breaker.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| annual_salary | DECIMAL(12,2) | Annual salary in Indian rupees |
| department | VARCHAR(80) | Employee's department |