I'm doing sum of two column of a one by one row in sequlize but cann't get solution. here is my query
const response = await general.findAndCountAll({
include: [{ model: amount,attributes: [
[sequelize.fn('sum',sequelize.col('user_count'),'+',sequelize.col('student_count')),
'total_count']]}
]
both user_count and student_count belong to amount table. please help and thanks in advance.