SQL
leetcode 1075. Project Employees I
무적김두칠
2023. 4. 21. 18:11
https://leetcode.com/problems/project-employees-i/description/
Project Employees I - LeetCode
Can you solve this real interview question? Project Employees I - Table: Project +-------------+---------+ | Column Name | Type | +-------------+---------+ | project_id | int | | employee_id | int | +-------------+---------+ (project_id, employee_id) is th
leetcode.com
|
1
2
3
4
5
6
|
# Write your MySQL query statement below
select p.project_id, round(sum(e.experience_years)/count(p.project_id), 2) average_years
from Project p
join Employee e
on p.employee_id =e.employee_id
group by p.project_id
|
cs |
반응형