Sequelize中的Group by和count

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

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

// 定义模型
class User extends Model {}
User.init({
  name: DataTypes.STRING,
  age: DataTypes.INTEGER
}, { sequelize, modelName: 'user' });

// 查询并使用Group by和count
User.findAll({
  attributes: ['age', [sequelize.fn('COUNT', sequelize.col('age')), 'count']],
  group: ['age']
}).then(results => {
  results.forEach(result => {
    console.log(`Age: ${result.age}, Count: ${result.get('count')}`);
  });
}).catch(error => {
  console.error('Error:', error);
});