Tredence interview question

How to filter, aggregate values in a dataframe