如何在Sequelize和Node中使用GROUP BY

Question

SELECT COUNT(volunteer_id) as countVolunteer, volunteer_type_id 
FROM `red_cross_vvts`
GROUP BY volunteer_type_id;

Answer 1

red_cross_vvts.findAll({
attributes: ['volunteer_type_id', [sequelize.fn('COUNT', 'volunteer_id'), 'countVolunteer']],
group: ['volunteer_type_id'],
});