Why does the below statement return no rows selected as the result?
Mr. King is the president of a company. Five managers report to him. All other employees report to these managers. Examine the code: SELECT employee.ename FROM emp employee WHERE employee.empno NOT IN (SELECT manager.MGR FROM emp manager);