SELECT COUNT(id), age FROM red_cross_volunteers GROUP BY age;

CodePudding user response：

Simply use Sequelize.fn in attributes option and group option while calling findAll:

const stats = await RedCrossVolunteers.findAll({
  attributes: [[Sequelize.fn('COUNT', Sequelize.col('id')), 'age_count'], 'age'],
  group: ['age']
})