Getting a different result set than the lecture's
I ran the second query suggested in the lecture (the one with IN), and I got 8 rows, the two main results have repeated. Could anyone help me see what is wrong here?
emp_manager e2 ON e1.emp_no = e2.manager_no
e2.emp_no IN (SELECT