could be great if having to_date considered

[MikeFilimonov]

Complete-SQL-Database-Bootcamp-Zero-to-Mastery/SQL Deep Dive/Subqueries/answers.sql

Line 24 in 3fa6008

SELECT emp_no, first_name, last_name

If the employees still have this manager we should be aware of the fact the condition to_date > now() is met. Otherwise the initial task should be set as "ever had manager with id = 110183"

[MikeFilimonov]

select x.emp_no, e.emp_no, e.first_name, e.last_name from
employees e,
(select emp_no, dept_no from dept_emp de
where de.to_date > now()) as de,
(select emp_no, dept_no from dept_manager dm
where dm.to_date > now()
and dm.emp_no = 110183
) as x
where x.dept_no = de.dept_no and
e.emp_no = de.emp_no

The query above results in zero records unless the condition "and dm.emp_no = 110183 " is commented out.