commit da92487181d490b3495401c42e87233e486676d1 parent 6b94927ea34790958adbfcfe7e945794d9429d3c Author: AndrewLockVI <andrewlaack1@gmail.com> Date: Tue, 11 Jul 2023 15:34:56 -0500 Completed project employees using mysql Diffstat:
| A | project-employees-i/project-employees.sql | | | 8 | ++++++++ |
1 file changed, 8 insertions(+), 0 deletions(-)
diff --git a/project-employees-i/project-employees.sql b/project-employees-i/project-employees.sql @@ -0,0 +1,8 @@ +--Given a table with projects and employees +--find the average tenure of all employees +--on a given project +SELECT Project.project_id, ROUND(AVG(Employee.experience_years), 2) AS average_years +FROM Project +LEFT JOIN Employee +ON Project.employee_id = Employee.employee_id +GROUP BY Project.project_id