Guest User

Untitled

a guest
May 23rd, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.50 KB | None | 0 0
  1. id || data || column
  2. 1 || 10 || x
  3. 1 || 20 || y
  4. 1 || 30 || y
  5. 1 || 15 || z
  6.  
  7.  
  8.  
  9. var queryPartOne = await db.table.findOne({
  10. attributes: [
  11. [db.Sequelize.fn("sum", db.Sequelize.col("data")), "datas"]
  12. ]
  13. )}
  14.  
  15. var queryPartTwo = await db.table.findOne({
  16. where: {
  17. column: z
  18. },
  19. attributes: [
  20. [db.Sequelize.fn("sum", db.Sequelize.col("data")), "datas"]
  21. ]
  22. )}
  23.  
  24. var net = queryPartOne.datas- queryPartTwo.datas * 1,25;
Add Comment
Please, Sign In to add comment