Determine Employees to Promote

Asked at Snowflake · Coding Questions · Difficulty: Medium

Given a list of employees with their project contribution scores, compute the total contribution for each employee across all projects, then sort the employees by their contribution score, identifying the top employees for promotion. The number of employees that can be promoted is determined by a given promotion ratio. Employee information includes their name and contributions to various projects. Output the list sorted by contribution in descending order and the list of employees identified for promotion (may include multiple employees).

Loading the problem…