1161. Project Employees I
My accepted SQL solution to LeetCode problem 1161, Project Employees I, running in 448ms.
- Difficulty: Easy
- SQL
- Runtime 448ms
- Memory 0.0B
- Updated
Read the problem on LeetCode View on GitHub
The problem statement is LeetCode’s and stays on their site. What follows is my accepted solution.
SQL
Accepted on LeetCode — runtime 448ms, memory 0.0B, accepted 2025-12-29.
SELECT p.project_id, ROUND(AVG(e.experience_years), 2) AS average_years
FROM Project p
JOIN Employee e ON p.employee_id = e.employee_id
GROUP BY p.project_id