列出收入大于或等于同一部门员工平均工资的员工

import pymysql

# 连接数据库
conn = pymysql.connect(host='localhost', user='root', password='password', db='company')
cursor = conn.cursor()

# 查询每个部门的平均工资
cursor.execute("SELECT department, AVG(salary) FROM employees GROUP BY department")
department_avg_salary = {row[0]: row[1] for row in cursor.fetchall()}

# 查询员工的工资信息
cursor.execute("SELECT employee_id, salary, department FROM employees")
employees = cursor.fetchall()

# 筛选出收入大于或等于同一部门员工平均工资的员工
high_earning_employees = []
for employee in employees:
    employee_id, salary, department = employee
    if salary >= department_avg_salary[department]:
        high_earning_employees.append(employee)

# 打印结果
for employee in high_earning_employees:
    print("Employee ID: {}, Salary: {}, Department: {}".format(employee[0], employee[1], employee[2]))

# 关闭数据库连接
conn.close()