Hola, espero que todos estén bien. Estoy usando Sequelize ORM en el nodo js. Tengo que sumar el precio final de los pedidos de un día y mostrar los datos, así que quiero encontrar algunos de los grupos de precios finales por el campo "creado en" pero no puedo para usar group by "createdAt" ya que hice uniones con otras tablas en la misma consulta

 Order.findAll( { logging:console.log, subQuery:false, include:[ { model: fulfillments, required:true, attributes:['fulfillment_status_id' , 'order_id'], include:{ model:fulfillmentStatus, where:{ delivery_status_name:fulfillmentStatusEnum.completed } } } ], attributes:['final_price', 'createdAt'], } )

los resultados que obtuve de la consulta anterior fueron

 SELECT "Order"."id", "Order"."final_price", "Order"."createdAt", "fulfillments"."id" AS "fulfillments.id", "fulfillments"."fulfillment_status_id" AS "fulfillments.fulfillment_status_id", "fulfillments"."order_id" AS "fulfillments.order_id", "fulfillments->fulfillmentStatus"."id" AS "fulfillments.fulfillmentStatus.id", "fulfillments->fulfillmentStatus"."delivery_status_name" AS "fulfillments.fulfillmentStatus.delivery_status_name", "fulfillments->fulfillmentStatus"."createdAt" AS "fulfillments.fulfillmentStatus.createdAt", "fulfillments->fulfillmentStatus"."updatedAt" AS "fulfillments.fulfillmentStatus.updatedAt" FROM "Orders" AS "Order" INNER JOIN "fulfillments" AS "fulfillments" ON "Order"."id" = "fulfillments"."order_id" INNER JOIN "fulfillmentStatuses" AS "fulfillments->fulfillmentStatus" ON "fulfillments"."fulfillment_status_id" = "fulfillments->fulfillmentStatus"."id" AND "fulfillments->fulfillmentStatus"."delivery_status_name" = 'completed';

pero quiero activar la consulta mencionada golpe:

 select sum(final_price) , "Orders"."createdAt" from "Orders" INNER JOIN fulfillments on fulfillments.order_id = "Orders".id INNER JOIN "fulfillmentStatuses" on fulfillments.fulfillment_status_id = "fulfillmentStatuses"."id" where "fulfillmentStatuses".delivery_status_name = 'completed' GROUP BY "Orders"."createdAt"

¿Alguien puede ayudar?