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