I am fairly new at using Firebird SQL and I would like some direction on how to include some calculations into my code.

For example I want to read a table, group by a part number and then get a total price for all the items in the group. Would this be something for a SP?

I have looked online but couldn't find a complete answer.

Thank you for any help/direction that you can give on this.