2 question three correct answers

is this the right code to get the answer??
SELECT 
    dept_name, gender, AVG(salary)
FROM
    employees e
        JOIN
    dept_emp de
        JOIN
    salaries s
        JOIN
    departments d ON (e.emp_no = de.emp_no
        AND e.emp_no = s.salary
        AND de.dept_no = d.dept_no)
GROUP BY dept_name , gender
ORDER BY dept_name;