使用Having和Group by序列化js未按预期工作

SELECT department, AVG(salary) as avg_salary
FROM employees
GROUP BY department
HAVING avg_salary > 50000;

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'your_username',
  password: 'your_password',
  database: 'your_database'
});

connection.connect();

connection.query('SELECT department, AVG(salary) as avg_salary FROM employees GROUP BY department HAVING avg_salary > 50000', (error, results, fields) => {
  if (error) throw error;

  // 尝试序列化结果
  try {
    const serializedData = JSON.stringify(results);
    console.log(serializedData);
  } catch (serializeError) {
    console.error('序列化失败:', serializeError);
  }

  connection.end();
});

const processedResults = results.map(row => ({
  department: row.department,
  avg_salary: row.avg_salary
}));

const serializedData = JSON.stringify(processedResults);
console.log(serializedData);

const processedResults = results.map(row => ({
  department: row.department,
  avg_salary: Number(row.avg_salary)
}));

const serializedData = JSON.stringify(processedResults);
console.log(serializedData);