Largest Salary by Department
Start Timer
0:00:00
Given a table called employees, get the largest salary of any employee by department
Example:
Input:
employees table
| Column | Type |
|---|---|
id |
INTEGER |
department |
VARCHAR |
salary |
INTEGER |
Output:
| Column | Type |
|---|---|
department |
VARCHAR |
largest_salary |
INTEGER |
.
.
.
.
.
.
.
.
.
Comments