Resolved: Error code keeps popping up
dept_manager m ON d.dept_no = m.dept_no
salaries s ON m.emp_no = s.emp_no
This is the code I put in, but I keep getting an error code about aggregate functions
Error Code: 1140. In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'employees.d.dept_name'; this is incompatible with sql_mode=only_full_group_by
The error you're seeing is related to the ONLY_FULL_GROUP_BY SQL mode in MySQL. When this mode is enabled, any column in the SELECT clause that isn't used in an aggregate function needs to be included in the GROUP BY clause.
In your query, you're trying to get the average salary (AVG(salary)) for each department (d.dept_name). Therefore, you need to group your results by department.
Please let me know if this makes sense.