如何在Sequelize.js中查询Group by和MAX(id

const Sequelize = require('sequelize');
const sequelize = new Sequelize('database', 'username', 'password', {
  host: 'localhost',
  dialect: 'mysql'
});

const Model = Sequelize.Model;
class ExampleModel extends Model {}
ExampleModel.init({
  id: {
    type: Sequelize.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  // 其他字段定义
}, {
  sequelize,
  modelName: 'example'
});

ExampleModel.findAll({
  attributes: [
    'id',
    [Sequelize.fn('MAX', Sequelize.col('id')), 'max_id']
  ],
  group: ['example.column'],
  order: [[Sequelize.literal('max_id'), 'DESC']]
})
.then(results => {
  // 处理查询结果
})
.catch(error => {
  // 处理错误
});