towards the end of the lecture, we add a group by m.emp_no into the inner join we made in the previous lesson to filter out duplicate values, I am getting an error code for 1055. I have ran the code mentioned before diving into joins, but I am not sure what else I need to do make sure it can run correctly.
 
SELECT
m.dept_no, m.emp_no, d.dept_name
FROM
dep_manager_dup m
INNER JOIN
departments_dup d ON m.dept_no = d.dept_no
group by m.emp_no
ORDER BY dept_no;
 
here is what I have when I attempt to run the code.