sequelize.org finand and count code example

Example 1: sequelize .all()

yourTableModel.findAll({
  //optional filters
  where: {},
  raw: true,
})

Example 2: sequelize findall 2 attributes

Model.findAll({
  attributes: [[sequelize.fn('COUNT', sequelize.col('hats')), 'no_hats']]
});