aggregation should select any non-null value without splitting the group