LATEST RECORD AND SUM SQL : I'm looking for solution for this problem.
Kindly need anyone help. Thanks.

Table:
[table set][1]

i want this output (show latest tier based on maximum transaction id)
[output][2]


  [1]: https://i.stack.imgur.com/76lYu.jpg
  [2]: https://i.stack.imgur.com/NqhwO.jpg


Thanks all