使用HAVING子句、COUNT aggregation和GROUP BY一次使用Sequelize过滤数据

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

const User = sequelize.define('User', {
  name: {
    type: DataTypes.STRING,
    allowNull: false
  },
  age: {
    type: DataTypes.INTEGER,
    allowNull: false
  },
  country: {
    type: DataTypes.STRING,
    allowNull: false
  }
});

const filteredUsers = await User.findAll({
  attributes: ['country', [sequelize.fn('COUNT', sequelize.col('country')), 'count']],
  group: ['country'],
  having: sequelize.where(sequelize.fn('COUNT', sequelize.col('country')), '>', 2)
});