Very fun, thank you :3c

Good kata, made me learn some stuff about Postgres

Reading other solutions I think mine might not be such a good solution

Tbh I don't feel qualified to comment on the quality of an answer as I have no profesional experience in SQL.

For future readers, the kara requires the median be interpolated

Also would be really nice if the kara included that in the description

Other than that it's a nice kara but I don't see how it would be a 5 kyu one

Good kara idea just feel like most of the time is spent doing non challenging auxiliary tasks. I feel like only the linking of the sales reps with the customers deserved the 4 kyu but otherwise still good kara

The kata requires that when 2 teams have the same ranking the team with the lower id is prefered, this however is not how the random results are implemented, leading to issues where sometimes they are not equivelent to the corect answer aka the query will place teams with the same ranking in random order. So you might need to re run it a couple times even if the solution is correct. Other than that great kara

Very clever, kinda embarased considering how simple and elegand your solution is compared to mine