leetcode

Solution 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