如何显示总价高于均价的每笔交易的客户名称？

// 连接数据库
const mysql = require('mysql');
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'database_name'
});

// 查询交易数据
const query = 'SELECT customer_name, transaction_amount FROM transactions';
connection.query(query, (error, results) => {
  if (error) throw error;

  // 计算均价
  const totalAmount = results.reduce((sum, transaction) => sum + transaction.transaction_amount, 0);
  const averageAmount = totalAmount / results.length;

  // 获取总价高于均价的客户名称
  const highAmountCustomers = results.filter(transaction => transaction.transaction_amount > averageAmount)
                                     .map(transaction => transaction.customer_name);

  // 展示或存储结果
  console.log('总价高于均价的客户名称：', highAmountCustomers);
});

// 关闭数据库连接
connection.end();