Project Employees I
Linked In
Problem Statement
Project managers at LinkedIn want to analyze the seniority level of different project teams to ensure a balanced mix of junior and senior talent.
Write an SQL query that reports the average experience years of all the employees for each project, rounded to 2 digits.
Rules:
- The average must be calculated per project_id.
- Round the resulting average to exactly 2 decimal places.
- Return the project_id and the calculated average_years.
- Results must be sorted by project_id in ascending order.
Tests your understanding of
Basic SQL, Joins, Aggregation, Rounding and Math Functions
Input Tables
project
| project_id(INTEGER) | employee_id(INTEGER) |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 2 | 4 |
employee
| employee_id(INTEGER) | name(VARCHAR) | experience_years(INTEGER) |
|---|---|---|
| 1 | Khaled | 3 |
| 2 | Ali | 2 |
| 3 | John | 1 |
| 4 | Doe | 2 |
Expected Output
| project_id(INTEGER) | average_years(FLOAT) |
|---|---|
| 1 | 2 |
| 2 | 2.5 |
Tags
EasyBasic SQLJoinsAggregationRoundingMath Functions
10-15 min
72%