Leetcode Problem 1075. Project Employees I

1075. Project Employees I

Leetcode Solutions

Calculating Average Experience Years per Project

Algorithm

Perform a LEFT JOIN between the Project and Employee tables on the employee_id column.
Use the GROUP BY clause to group the results by project_id.
Select the project_id and the average of experience_years for each group.
Use the ROUND function to format the average to 2 decimal places.
Return the project_id and the formatted average as average_years.


erDiagram
    Project {
        int project_id
        int employee_id
    }
    Employee {
        int employee_id
        varchar name
        int experience_years
    }
    Project ||--o{ Employee : ""

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Loading...

Suggested Answer

Answer

Full Screen

Copy Answer Code

Loading...