leetcode

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

with-missing-info.sql (596B)

      1 --Given a list of employees
      2 --return all employees that 
      3 --are either missing their employee name
      4 --or salary
      5 SELECT employee_id
      6 FROM (
      7     SELECT COALESCE(Employees.employee_id, Salaries.employee_id) AS employee_id
      8     FROM Employees
      9     LEFT JOIN Salaries ON Employees.employee_id = Salaries.employee_id
     10     WHERE Salaries.salary IS NULL
     11 
     12     UNION
     13 
     14     SELECT COALESCE(Employees.employee_id, Salaries.employee_id) AS employee_id
     15     FROM Employees
     16     RIGHT JOIN Salaries ON Employees.employee_id = Salaries.employee_id
     17     WHERE Employees.name IS NULL
     18 ) AS subquery
     19 ORDER BY employee_id ASC;