I have a different answer than 365 data solution when I this code
employees e ON dm.emp_no = e.emp_no
departments d ON dm.dept_no = dm.dept_no
titles ON e.emp_no = titles.emp_no
it back with 216 row while when yours is back only with 24 rows
I also noticed that same employee can work in different departments
Thanks for reaching out.
Please excuse me for the belated answer.
There are many differences between the query you've executed and the one we discuss in the lecture.
Among the differences, there are:
- you have included the "titles" data table into the equation (i.e. you have referred to the data contained in it)
- you have matched the department number column from the 'department manager' table twice, as you opposed to matching this column with the column bearing the same name from the 'departments' table.
Please remove them from your query and you should be able to obtain an answer containing 24 rows.
Hope this helps.