leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
1075.sql (157B)
0 SELECT project_id, ROUND(AVG(experience_years), 2) AS average_years
1 FROM Project P
2 LEFT JOIN Employee E
3 ON P.employee_id = E.employee_id
4 GROUP BY project_id