mysql - SQL 写平均工资

Question

他想写部门和他们的平均工资，其中员工目前收入超过 8,000

我试过这种方式，但它显示 - 1111 - 组功能的使用无效

ELECT departments.dept_name, AVG(salaries.salary) FROM departments, salaries 
INNER JOIN employees ON salaries.emp_no = employees.emp_no 
INNER JOIN dept_manager ON employees.emp_no = dept_manager.emp_no 
INNER JOIN dept_emp ON departments.dept_no = dept_emp.emp_no
WHERE AVG(salaries.salary)>8000

和

列出与 1/01/0985 和 1/02/1985 之间的员工同名的所有员工。

SELECT  emp_no, first_name
    FROM  employees AS pole1
    WHERE  EXISTS (
        SELECT  pole2.emp_no
            FROM  employees AS pole2, salaries
            WHERE  pole1.first_name = pole2.first_name
              AND  pole1.emp_no <> pole2.emp_no
              AND  salaries.from_date BETWEEN 01-01-1985 AND 01-02-1985 
                  ) 

此查询不想完成

标签： mysqlsqlmariadb