image_2022-04-18_15-08-58.png
32.2 KB
#N1965. Employees With Missing Information
problem link
#solution
problem link
#solution
select employee_id from employees
where employee_id not in (select employee_id from salaries)
union
select employee_id from salaries
where employee_id not in (select employee_id from employees)
order by employee_id;