leetcode

Leetcode submissions
git clone git://git.laack.co/leetcode.git
Log | Files | Refs | README

project-employees.sql (299B)

      1 --Given a table with projects and employees
      2 --find the average tenure of all employees
      3 --on a given project
      4 SELECT Project.project_id, ROUND(AVG(Employee.experience_years), 2) AS average_years
      5 FROM Project
      6 LEFT JOIN Employee
      7 ON Project.employee_id = Employee.employee_id
      8 GROUP BY Project.project_id