Query problem

Ok, hello. I’m having some trouble with a query to a database.

Basically the problem is with the data I require. The databse query is something like this:

image.png724×288 8.13 KB

I need to “concatenate” (I don’t think that’s the specific word for it) the apartment column be one and sum the balance column, so I would get in the query:

image.png724×224 6.27 KB