Your question is Highest Salary and Ranking. 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.
Meesho's People Analytics team needs a quick view of the maximum salary currently recorded in its employee dataset. Write a PostgreSQL query that returns the highest salary value from the employees table.
highest_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(12,2) | Annual salary in Indian rupees |