728x90
https://leetcode.com/problems/project-employees-i/
SELECT project_id, ROUND(AVG(experience_years), 2) AS average_years
FROM Project
INNER JOIN Employee ON Project.employee_id = Employee.employee_id
GROUP BY project_id;728x90
'IT > 코딩테스트' 카테고리의 다른 글
| [Leetcode] 1141. User Activity for the Past 30 Days I (0) | 2023.09.06 |
|---|---|
| [Leetcode] 1978. Employees Whose Manager Left the Company (0) | 2023.09.05 |
| [Leetcode] 2843. Count Symmetric Integers (0) | 2023.09.03 |
| [Leetcode] 1051. Height Checker (0) | 2023.09.02 |
| [Leetcode] 88. Merge Sorted Array (1) | 2023.09.02 |