Intermediate · SQL · Window functions

Highest-paid employee in each team

Commonly asked: Asked at service and product companies alike · ~10 min

Return team, name and salary of the top earner(s) in each team.