1075. Project Employees I
一、题目描述
Table: Project
Column Name | Type |
---|---|
project_id | int |
employee_id | int |
(project_id, employee_id) is the primary key of this table.
employee_id is a foreign key to Employee table.
Table: Employee
Column Name | Type |
---|---|
employee_id | int |
name | varchar |
experience_years | int |
employee_id is the primary key of this table.
Write an SQL query that reports the average experience years of all the employees for each project, rounded to 2 digits.
The query result format is in the following example:
Project table:
project_id | employee_id |
---|