Your question is a bit unclear for me.
Do you ask how to write SQL to sum up
the total of each item ?
Once your problem is solved please do:
Use the Topic Tools button to mark as Solved and
Upvote the answer(s) that helped you to solve the issue postimage.org can be used for screenshots.
Get on the inside track at https://www.qtworldsummit.com/