aggregation FIRST and LAST pick among the records that hold a value