如何从数据库中获取每个表的最新值的平均值

import mysql.connector

# 连接数据库
conn = mysql.connector.connect(
    host='数据库主机',
    user='用户名',
    password='密码',
    database='数据库名'
)

cursor = conn.cursor()

# 查询每个表的最新值
cursor.execute("SELECT table_name, MAX(value) FROM schema_name.table_name GROUP BY table_name")

latest_values = cursor.fetchall()

# 计算平均值
total = sum([value for _, value in latest_values])
average = total / len(latest_values)

# 打印结果
for table, value in latest_values:
    print(f"Table: {table}, Latest Value: {value}")

print(f"\nAverage Latest Value: {average}")

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