1// Counting number of totalPrice from column itemPrice table
2Model.findAll({
3 attributes: {
4 include: [
5 [sequelize.fn('COUNT', sequelize.col('itemPrice')), 'totalPrice']
6 ]
7 }
8});
1// for gettting all username in uppercase
2instance.update({
3 username: sequelize.fn('upper', sequelize.col('username'))
4});