leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

1978.sql (208B)

      1 SELECT E.employee_id
      2 FROM Employees E
      3 LEFT JOIN Employees M
      4 ON E.manager_id = M.employee_id
      5 WHERE E.salary < 30000 AND 
      6       M.employee_id IS NULL AND 
      7       E.manager_id  IS NOT NULL
      8 ORDER BY E.employee_id