Sequelize join order by / group by

join 되는 기준으로 order by / group by

    const table_a = await models.TABLE_A.findAll({
      include: [
        {
          as: "table_b",
          model: models.TABLE_B,
          required: true,
        },
      ],
      order: [[ {model: models.TABLE_B, as: "table_b" }, "id", "DESC"]],
      group: [[ {model: models.TABLE_B, as: "table_b" }, "no"]]
    });