Sequelize Postgres -选择不在groupby中的字段

const { Sequelize, Model, DataTypes } = require('sequelize');

// 创建Sequelize实例
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'postgres'
});

// 定义模型
class User extends Model {}
User.init({
  id: {
    type: DataTypes.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  name: {
    type: DataTypes.STRING,
    allowNull: false
  },
  age: {
    type: DataTypes.INTEGER,
    allowNull: false
  },
  city: {
    type: DataTypes.STRING,
    allowNull: false
  }
}, {
  sequelize,
  modelName: 'user'
});

// 查询数据
User.findAll({
  attributes: [
    'city', // 在GROUP BY中列出的字段
    [sequelize.fn('max', sequelize.col('age')), 'maxAge'] // 不在GROUP BY中的字段
  ],
  group: ['city']
}).then(users => {
  console.log(users);
}).catch(error => {
  console.error(error);
});