How to do query (sum or average) based on criteria of data?

Hi there

I’m quite new with this bubble.io on handling the query for the database. I get used to with SQL stuff or similar.

I had a simple custom data type (table) with a few columns and it has a number and I want to get the SUM/AVERAGE of this ColumnA filtered by let’s say WHERE ColumnC= “XX”.

Any guidance/feedback or article/video that will be good.

Thank you

Never mind. We worked out on how to do this.