Your question is SQL Join for Top Earners. 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.
Roku's People Analytics team needs a simple report of the employees with the highest current salaries. Write a PostgreSQL query using the employees table only.
employee_id as a deterministic tie-breaker.| Column | Type | Description |
|---|---|---|
| employee_idPK | INT | Unique employee identifier |
| employee_name | VARCHAR(100) | Employee's full name |
| team | VARCHAR(100) | Roku team or department |
| salary | NUMERIC(10,2) | Current annual salary in USD |